{"id":9846,"date":"2014-10-31T05:02:47","date_gmt":"2014-10-30T18:02:47","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=9846"},"modified":"2014-10-31T05:02:47","modified_gmt":"2014-10-30T18:02:47","slug":"sqlite-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/sqlite-primer-tutorial\/","title":{"rendered":"SQLite Primer Tutorial"},"content":{"rendered":"
\"SQLite<\/a>

SQLite Primer Tutorial<\/p><\/div>\n

Want to quote the landing page of the database package called SQLite<\/a> …<\/p>\n

\nSQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.\n<\/p><\/blockquote>\n

… have to say, have not used SQLite a lot (except with Django<\/a>, but the install, as shown with today’s tutorial (which also includes a bit of the command line functionality equivalent of SQL*Plus<\/a> for<\/a> Oracle<\/a><\/i> for SQLite) is very easy and straightforward, a contrast it must be said, to the way it feels, sometimes, installing Oracle or MS-SQL or MySQL or PostgreSQL or Advantage or even matters concerning Access. Of course, all things database are worth pursuing, as the organization of data is of paramount importance when deciding on application design, and understanding what can interface to what as far as actions on data, are concerned.<\/p>\n

Even if you’re unfamiliar, like me, with SQLite, there is good online help, or you can know that search engine searches and forums and blogs will help you out a lot. Often the search engine analysis of how a database concatenates strings is instructive, and leads to lots of other research … for SQLite, used this link<\/a> to do that search.<\/p>\n

Here is a link for SQLite download<\/a> options. Hope to see you again ext time.<\/p>\n

Here is a Wikipedia informational link for SQLite<\/a>.<\/p>\n

If this was interesting you may be interested in this<\/a> too.<\/p>\n