Features / PHP SQLite



SQLite is undoubtedly one of the best tools to store data when you need simplicity and why to call SQLite as a tool and not a database? The answer is quite simple too. SQLite is a library developed in C and it can be easily integrated with PHP, a sign on the PHP version 5 it is already integrated into the language. The great advantage of SQLite is that it no requires DBMS (System Manager database) to perform routines like insert, update, update and create tables. This all can be done directly from the language which means that there is a high gain in time and processing.


The SQLite is stored on the same server where the application is installed. It writes and creates the file '.db' in a very simple and compact way, this means to save resources. The various projects can take advantage of all this simplicity and thus gain in performance. The syntax used in SQLite is the standard SQL that is very simple to work with. As a free tool, the database costs is exempted. This is an important feature once small projects should not to generate a high demand to justify this kind of spending. That is why using SQLite in small sites and web applications that do not generate many data requests and complex processing.

But when you are developing a project, is essential to have a tool that can assist you. With Scriptcase you can easily connect to SQLite database, all you need to inform to connect to the SQLite is:

  • Connection Name: It will help you identify the connection among the others.
  • DBMS Driver: It Will show a list with all drivers available.
  • PATH: The full path to the file '.Db'.

PHP SQLite Connection

Once you connect Scriptcase with your database, it will read your tables and create applications based on the desired tables. Scriptcase will identify all special characteristics from your table, such as primary keys, foreign key, auto-increments, among others, and will show that at the application level. All the CRUD (Create, Read, Update and Delete) actions will be managed by the Scriptcase. On forms and reports all the navigation, searches and filters (Static or Dynamic) will be also handled by Scriptcase automatically.

Scriptcase support stored procedures and all SQL statements (joins, order by, group by, among others) of SQLite, why lose time when you have Scriptcase to help you out?! Download it now and test it free for 20 days!

Special Offers