Results 1 to 1 of 1

Thread: SQL engine for text files

  1. #1
    Assadministrator kung foo man's Avatar
    Join Date
    Jun 2012
    Location
    trailerpark
    Posts
    2,010
    Thanks
    2,102
    Thanked 1,084 Times in 753 Posts

    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://github.com/wishvamalli/doSQL
    Last edited by kung foo man; 17th November 2015 at 01:10. Reason: Add 2nd sql file engine
    timescale 0.01

  2. The Following User Says Thank You to kung foo man For This Useful Post:

    maxdamage99 (25th December 2015)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •