Compact database file like solution for storing small information with php

Question

I am developing a facebook app using php SDK, my app is small and simple meant for a community project and its database contains only one table with 6 columns and hardly 10-20 lines of record.

I am using heroku for hosting my app which doesn’t provide a direct database hosting capability. Plus I think storing such small information in a total separate database server would not be very resource efficient.

I am looking for some simple solution for it, something like a compact database file which I can just upload to the directory and my code can get connected to it and retrieve information from it using a sql query, a simple and efficient solution. Or any other nice suggestions to handle this.

My app doesn’t require storing any information to the database on runtime but only retrieval from already existing information, simple something like:

Select * from table where column LIKE %value%

Kindly guide me with this. Thank you.

Answer 1

How about SQLlite? http://www.sqlite.org/ http://www.php.net/manual/en/sqlite.installation.php

Answer 2

You should check SQLite (php functions here).

Answer 3

Sqlite is the tool for the job; there is a built-in (for 5.0.0 >= PHP version < 5.4.0) PHP extension for it.