Flutterby™! : textql

Next unread comment / Catchup all unread comments User Account Info | Logout | XML/Pilot/etc versions | Long version (with comments) | Weblog archives | Site Map | | Browse Topics

textql

2014-07-15 17:36:02.430788+00 by Dan Lyke 3 comments

TextQL -Allows you to easily execute SQL against structured text like CSV or TSV.

SQLite for text files. In case any of y'all ever need to do reporting or summarizing of data delivered in field/comma separated structured text, or write out to it...

[ related topics: Law Databases ]

comments in ascending chronological order (reverse):

#Comment Re: made: 2014-07-15 19:58:06.645498+00 by: Larry Burton

This could be an extremely handy little tool.

#Comment Re: made: 2014-07-16 01:54:59.216936+00 by: meuon

Think this is what perl is for.. and yet I like this, will have to play with some real datasets. THANK YOU.

#Comment Re: made: 2014-07-18 17:36:24.432537+00 by: concept14

We have a proprietary equivalent where I work and it is very useful. You can even do a join between a CSV file and a SQL Server table. (But it has all the usual downsides of reinventing the wheel.)