It even has a nice extra feature over MySQL: encryption of data files (though I don't see a direct need for that during development for me personally). It requires no server and everything is put neatly in one file, which makes back-upping and sharing databases among developers easier. To me it looks like H2 database is the easiest to manage. Let's start with the good stuff. Below is a comparison of SQLite, H2 database engine and MySQL embedded version. Second, an easy to setup database is great for bringing new developers up to speed with development as fast as possible. First, I wanted it to be compatible with MySQL so that I can keep using that easy self-contained database for development even after the application has gone into production. My criteria were that the alternative should be as easy to use as SQLite and compatible with MySQL, based on two reasons. When looking for alternatives to SQLite, I came across two suitable candidates: H2 database engine and a MySQL embedded version. And that's not all! Keep reading to see why. But then again, why would you want an alternative for SQLite? Well, to name a few reasons: MySQL compatibility and support for hash indices. There have not been any alternatives for SQLite when developing in PHP with MySQL as a target platform. ![]() Then later on, the application is commonly migrated to a production DBMS (e.g. It's easy, self-contained, requires no configuration, no server and all the data is kept neatly in just one file. ![]() SQLite is a popular choice for PHP programmers to kick-start their development.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |