Search results for tag #sqlite
☮️#gnuplot is great. I've been feeding the results of #sqlite queries into it via org-babel, and it works almost perfectly; the only exception being that I can't use column names in the gnuplot dataset.
Maybe I'll write a blog post about that... In some moderately distant future.
It feels much less accessible compared to #matplotlib, but not more so than #emacs, I guess. And it's great not to carry any dependencies except the gnuplot binary, particularly for the Org Mode use case.
The charts sometimes look like a hello from the 90s, but to me it's a plus that they don't give the "matplotlib on defaults" vibe which is omnipresent in modern science :D
![#+NAME: mastodon-posts-monthly
#+begin_src sqlite
SELECT strftime('%Y-%m', timestamp, 'unixepoch') month, count(*) FROM mastodon_post
WHERE is_reply = 0
GROUP BY strftime('%Y-%m', timestamp, 'unixepoch')
#+end_src
#+HEADER: :post out_wrap(caption="Public Mastodon posts per month", data=*this*) :results raw
#+begin_src gnuplot :noweb yes :var data=mastodon-posts-monthly :file ./img/mastodon-posts-monthly.png
reset
set title "Mastodon Posts per Month"
set xlabel "Month"
set ylabel "Post count"
set xdata time
set timefmt "%Y-%m"
set format x "%Y %b"
set xtics rotate by 45 right
set boxwidth 0.8 relative
set grid lc rgbcolor "#A0A0A0" lt 1 lw 0.5
set grid back
plot data u 1:2 w boxes notitle fs solid lc rgb "web-blue"
#+end_src
#+RESULTS:
#+CAPTION:Public Mastodon posts per month
[An image with the bar chart]](https://media.bsd.cafe/bsdmmedia01/media_attachments/files/113/760/955/407/727/906/original/1855ad10ee83a021.png "#+NAME: mastodon-posts-monthly
#+begin_src sqlite
SELECT strftime('%Y-%m', timestamp, 'unixepoch') month, count(*) FROM mastodon_post
WHERE is_reply = 0
GROUP BY strftime('%Y-%m', timestamp, 'unixepoch')
#+end_src
#+HEADER: :post out_wrap(caption=\"Public Mastodon posts per month\", data=*this*) :results raw
#+begin_src gnuplot :noweb yes :var data=mastodon-posts-monthly :file ./img/mastodon-posts-monthly.png
reset
set title \"Mastodon Posts per Month\"
set xlabel \"Month\"
set ylabel \"Post count\"
set xdata time
set timefmt \"%Y-%m\"
set format x \"%Y %b\"
set xtics rotate by 45 right
set boxwidth 0.8 relative
set grid lc rgbcolor \"#A0A0A0\" lt 1 lw 0.5
set grid back
plot data u 1:2 w boxes notitle fs solid lc rgb \"web-blue\"
#+end_src
#+RESULTS:
#+CAPTION:Public Mastodon posts per month
[An image with the bar chart]")
Alt...
#+NAME: mastodon-posts-monthly
#+begin_src sqlite
SELECT strftime('%Y-%m', timestamp, 'unixepoch') month, count(*) FROM mastodon_post
WHERE is_reply = 0
GROUP BY strftime('%Y-%m', timestamp, 'unixepoch')
#+end_src
#+HEADER: :post out_wrap(caption="Public Mastodon posts per month", data=*this*) :results raw
#+begin_src gnuplot :noweb yes :var data=mastodon-posts-monthly :file ./img/mastodon-posts-monthly.png
reset
set title "Mastodon Posts per Month"
set xlabel "Month"
set ylabel "Post count"
set xdata time
set timefmt "%Y-%m"
set format x "%Y %b"
set xtics rotate by 45 right
set boxwidth 0.8 relative
set grid lc rgbcolor "#A0A0A0" lt 1 lw 0.5
set grid back
plot data u 1:2 w boxes notitle fs solid lc rgb "web-blue"
#+end_src
#+RESULTS:
#+CAPTION:Public Mastodon posts per month
[An image with the bar chart]
@amoroso this is missing the fact that #SQLite was created originally as essentially a #Tcl extension. That also helps to shine line on some of its interesting idiosyncrasies. The @tcl_tk language still plays an important role in SQLite’s development. Basically if you like SQLite, and you should, you’ll like like the Tcl language.
SQLite is a remarkable piece of software and I've always been curious about the system and the project. Here are several little known facts about SQLite.
#SQLite is the most deployed and most used database. There are over one trillion SQLite databases in active use.
It is maintained by three people. They don’t allow outside contributions.
