If you have PHP and Apache running then I would suggest MySQL. Just drop adminer.php and it is easy to manage the database.
XAMPP uses MySQL. Personally for my client work I only use MySQL server, but on my local development machines I only have XAMPP installed when I'm creating and testing websites for clients.how about using MySQL local with XAMPP?
Hi,
Unless you have many tables and more then couple hundreds of inserts per day any of these will work for you.
Seems that you want to use Sqlite, maybe because you know it already?
If you have no preference you may want to go with MySQL as this is true client/server database and little more fit for your setup.
MongoDB is a well-established, non-relational database system offering improved flexibility and horizontal scalability, but at the cost of some safety features of relational databases, such as referential integrity.
To provide better guidance more information is required:
How many users?
How many inserts daily?
How many tables?
The kicker is, if you look at the source of most web applications that use SQL DB's as a back end, they completely ignore the underlying DB's security mechanism and view system. All the security checks and view building are done in code. In such a case, you may as well stick with SQLite, if that fits the bill. One of the counter-arguments that I have seen against SQLite is that it is very sparse on types. For that, there are a couple of other embedded databases such as H2, Derby or HSQLDB that my fit the bill without requiring a separate install of a DB system. H2 has a comparison table comparing itself with the other two embedded DB's mentioned and MySQL and PostgreSQL (https://www.h2database.com/html/main.html).However since this is multiuser database I think you may want to eliminate sqlite db.
However since this is multiuser database I think you may want to eliminate sqlite db.
jerry07 said:
However since this is multiuser database I think you may want to eliminate sqlite db.Thats not entirely a true statement. It doesnt support multiple connections. If your app only uses one conenction to access the database then mutliple users are defintely supported.
No problem. H2 is really good. Lots of options. Documentation is really good too.OliverA and tchart,
Thanks for introducing H2 I will have to have a look at this.
Dbeaver is an excellent toolAlso if anyone is after a good SQL editor/UI then check out Dbeaver. Very good and automatically downloads jars files as required.
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?