Electron app with database

javascript sql node.js database electron
gian29 picture gian29 · Jul 1, 2018 · Viewed 17.7k times · Source

I'm creating a web app for ticket reservation. The only problem is the database. I don't want to tell my client to install XAMPP or set a database, etc.

Is there any way to package the app with the database?

Answer

Jacobm001 picture Jacobm001 · Jul 1, 2018

SQLite is a good option for a local database that you can ship with your application. It won't require the user to setup or install any extra dependencies. It's certainly not as full featured as a full on server, but it should be good enough for a local desktop app.

Related questions

Import sql file in node.js and execute against PostgreSQL

I'm looking for an efficient way to take a raw sql file and have it executed synchronously against a postgres database, akin to if you ran it through psql. I have an sql file which creates all databases, imports data, …

Read More
How do I properly insert multiple rows into PG with node-postgres?

A single row can be inserted like this: client.query("insert into tableName (name, email) values ($1, $2) ", ['john', '[email protected]'], callBack) This approach automatically comments out any special characters. How do i insert multiple rows at once? I need to …

Read More
Conditional filter using Knex.js and SQL with multiple search criteria

I have a database of items that my user needs to be able to search. They can apply different filters such as category, searchTerm, itemType. I know how to apply each of these filters in a knex query, but am …

Read More