SQLite is a lightweight but powerful SQL database. Linux, Windows & probably other platforms. In Windows, it's just a DLL sitting there until called, and one file per database. There is no ginormous server requiring care & feeding - access is determined by whatever the database file access is set for, and no Administrator. There is a command-line tool for creating and managing tables etc., but I do that from within Python.
For Python users, it's even better - PySQLite is a Python DB interface-compliant module that makes it even simpler. I have an app developed in Windows (PythonCard) that I'm now porting to Linux, and plan to do a TechPrezzy about in a few months. http://www.hwaci.com/sw/sqlite/ http://freshmeat.net/releases/89953/ http://sourceforge.net/projects/pysqlite Here's a snippet of code:- conn=sqlite.connect("RanchBiz.db") # Creates a Connection # Connect to it, or create it if non-existent cursor = self.conn.cursor() # Creates a Cursor cursor.execute("SELECT * FROM GUEST WHERE G_PARTY_ID="+str(partyID)) tblGUEST=self.cursor.fetchall() # Creates a Table of the result <trivia omitted above for brevity> -- John Hall <[EMAIL PROTECTED]> Calgary, Alberta, Canada. "Helping People Prosper in the Information Age".
