SQL engine for text files

[kung foo man]

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

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

$ 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://github.com/wishvamalli/doSQL