SQL engine for text files

Found some nice project: https://fedorahosted.org/squeal/

There are many examples on front page, just gotta copy/paste one:

Code:

---

$ squeal "count(*)", source from /var/log/messages* group by source order by "count(*)" desc
count(*)|source              |
--------+--------------------+
1633    |kernel              |
1324    |NetworkManager      |
98    |ntpd                |
70    |avahi-daemon        |
63    |dhclient            |
48    |setroubleshoot      |
39    |dnsmasq            |
29    |nm-system-settings  |
27    |bluetoothd          |
14    |/usr/sbin/gpm      |
13    |acpid              |
10    |init                |
9    |pcscd              |
9    |pulseaudio          |
6    |gnome-keyring-ask  |
6    |gnome-keyring-daemon|
6    |gnome-session      |
6    |rsyslogd            |
5    |rpc.statd          |
4    |vpnc                |
3    |gdm-session-worker  |
2    |auditd              |
2    |console-kit-daemon  |
2    |libvirtd            |
2    |rpcbind            |
1    |nm-dispatcher.action|
1    |restorecond        |

---

This might be pretty useful/powerful when used on sound .csv files, CoD log files etc.


Edit: aaaand found a second SQL file engine, which is basically a very simple Python script, reusing SQLite via temp table, so it supports full blown SQL:

https://www.youtube.com/watch?v=Nxx2T0BOp3k

https://github.com/wishvamalli/doSQL