SQLite support has been added to PyTonic

Posted by: Pytonic on 22 Sep 2011

We just added support of the great SQLite embedded database engine in PyTonic.

SQLite will let you provide database applications without the need of an external database server like Microsoft SQL Server or MySQL when multi-users management is not required.

You can start your development with SQLite and then move to MySQL or SQL Server when you start going in production.

To enable the SQLite support, use this parameters in your "config/database.xml" file :

<?xml version="1.0" encoding="utf-8"?>
<ConfigurationHelper xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <DatabaseEngine>sqlite</DatabaseEngine>
  <DatabaseServer></DatabaseServer>
  <DatabaseName>database/data.db</DatabaseName>
  <DatabaseUser></DatabaseUser>
  <DatabasePassword></DatabasePassword>
</ConfigurationHelper>

The "DatabaseEngine" should be set to "sqlite" (instead of "mssql" or "mysql") and the "DatabaseName" is the folder inside your PyTonic project + database file name.

If you want the database to be stored in a folder outside your project, use the "DatabaseServer" value.

<?xml version="1.0" encoding="utf-8"?>
<ConfigurationHelper xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
	<DatabaseEngine>sqlite</DatabaseEngine>
	<DatabaseServer>c:/sqlite</DatabaseServer>
	<DatabaseName>data.db</DatabaseName>
	<DatabaseUser>sa</DatabaseUser>
	<DatabasePassword></DatabasePassword>
</ConfigurationHelper>