Pytonic is an open source full integrated IDE that makes easy to build business applications with IronPython.
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>