[PLUG] SQLite follow-up

[JP Vossen <jp@jpsdomain.org>]

Thanks again to Walt for taking his talk on the road to PLUG W, it was 
very useful.

I poked around a bit more and found some useful links.  Something I 
learned is that the code is public domain, so you can do anything at all 
with it.

SQLite:
http://www.mawode.com/~waltman/talks/sqlite_func.plug.pdf
	Walt's slide on extending SQLite with Perl

http://www.sqlite.org/
	Home page, has a nice FAQ and also a wiki
http://en.wikipedia.org/wiki/SQLite
	Wikipedia on SQLite (interesting and quick summary/history)
http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html
	Useful and extensive (not short) SQLite Tutorial

http://sqlitebrowser.sourceforge.net/
	Simple cross-platform (QT) SQLite GUI browser/manager

https://addons.mozilla.org/en-US/firefox/addon/5817
http://code.google.com/p/sqlite-manager/
	SQLite GUI browser/manager XUL plugin


Related:
http://developers.slashdot.org/developers/08/05/20/2150246.shtml
	F/OSS Flat-File Database?
http://www.ideaspike.com/dbtxt.shtml
	dbtxt - A tiny PD database in Python (flat file)


There is a vaguely similar tool called the "Microsoft Log Parser" that 
is--wait for it--Windows only.  It allows you to attach to a flat-file 
in many different formats and run SQL-similar commands against the file. 
  It also allows many different output formats.  Much more generic than 
SQLite, but nothing you can't do in Perl, Python or whatever.  May be 
useful, especially to non-programmers familiar with SQL who are stuck on 
Windows.  The book has a log of good material and examples.

http://www.windowsdevcenter.com/lpt/a/6027
	Using Log Parser 2.2
http://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&displaylang=en
	Download Log Parser 2.2
http://www.logparser.com/
	The "Unofficial Log Parser Support Site"
http://www.amazon.com/Microsoft-Log-Parser-Toolkit-undocumented/dp/1932266526
	Microsoft Log Parser Toolkit book (very good -JP)
http://www.google.com/search?q="Microsoft+Log+Parser+Toolkit";


Speaking of Perl, there's the Perl DBD::CSV module that allows you to 
treat flat CSV files like they were a DB. See 
http://search.cpan.org/~jzucker/DBD-CSV/lib/DBD/CSV.pm and maybe even 
http://search.cpan.org/~rehsack/SQL-Statement/lib/SQL/Statement.pm.


Hope this is useful,
JP
----------------------------|:::======|-------------------------------
JP Vossen, CISSP            |:::======|      http://bashcookbook.com/
My Account, My Opinions     |=========|      http://www.jpsdomain.org/
----------------------------|=========|-------------------------------
"Microsoft Tax" = the additional hardware & yearly fees for the add-on
software required to protect Windows from its own poorly designed and
implemented self, while the overhead incidentally flattens Moore's Law.
___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug