SQLite
Posted: Sun Nov 30, 2014 2:21 pm
Hello.
I’m proud to announce that I implemented in the STHS a new functionality that I was thinking about for a long time, a flat file SQL database! It’s based on SQLite (http://www.sqlite.org/), a software library that implements a self-contained, server less, zero-configuration, transactional SQL database engine. Using php code (http://php.net/manual/en/book.sqlite.php), you can easily read this flat file SQL database and create a custom website with it. Since there is no MySQL database to run in the backend, it easy to setup, to maintain and to support (Ok, this part is for me only). Another advantage is that the database will get recreated from scratch by the STHS each time you output it. This means that to update your website, you simply need to upload the STHS database file each day like the other HTML file and STHS Client file; no funky database update with time-out or error.
You can find the information about the database here: http://sths.simont.info/DatabaseInfo.php
You’ll see the name of the database tables, their corresponding schema (Field Name & Data Type) and some extra information about some field name.
In the version 2.2.7, the databases will be available to output via manual command because I’m not 100% sure the code is bug prove. Doing SQL Insert command when you have over 60 columns is very error prone work. In 2.2.7, I want to give you the possibility to look at the DB and report errors or missing information (Data or Field Type) in the database.
Note: There is multiple of Windows Software that allows you to open a SQLite database. I’m using this one:http://sqlitedbrowser.sourceforge.net/
In the next months, I want to create a brand new STHS Website based on this STHS SQL database in PHP and offer it to everyone who used the STHS. The PHP code will be free of charge and you’ll be able to edit yourself after you download it from the STHS website. If anyone in interested in collaborating with me on this project, please contact me.
Thank you.
I’m proud to announce that I implemented in the STHS a new functionality that I was thinking about for a long time, a flat file SQL database! It’s based on SQLite (http://www.sqlite.org/), a software library that implements a self-contained, server less, zero-configuration, transactional SQL database engine. Using php code (http://php.net/manual/en/book.sqlite.php), you can easily read this flat file SQL database and create a custom website with it. Since there is no MySQL database to run in the backend, it easy to setup, to maintain and to support (Ok, this part is for me only). Another advantage is that the database will get recreated from scratch by the STHS each time you output it. This means that to update your website, you simply need to upload the STHS database file each day like the other HTML file and STHS Client file; no funky database update with time-out or error.
You can find the information about the database here: http://sths.simont.info/DatabaseInfo.php
You’ll see the name of the database tables, their corresponding schema (Field Name & Data Type) and some extra information about some field name.
In the version 2.2.7, the databases will be available to output via manual command because I’m not 100% sure the code is bug prove. Doing SQL Insert command when you have over 60 columns is very error prone work. In 2.2.7, I want to give you the possibility to look at the DB and report errors or missing information (Data or Field Type) in the database.
Note: There is multiple of Windows Software that allows you to open a SQLite database. I’m using this one:http://sqlitedbrowser.sourceforge.net/
In the next months, I want to create a brand new STHS Website based on this STHS SQL database in PHP and offer it to everyone who used the STHS. The PHP code will be free of charge and you’ll be able to edit yourself after you download it from the STHS website. If anyone in interested in collaborating with me on this project, please contact me.
Thank you.