search

simov / express-admin

MySQL, MariaDB, PostgreSQL, SQLite admin for Node.js
MIT License
1.18k stars 223 forks source link

SQLite as DB engine #20

Closed philippwiddra closed 10 years ago

philippwiddra commented 10 years ago

Is it possible to use a SQLite file as database? This would be very convenient for some cases where embedded databases are used.

Most (all?) of the calls should work like in SQL i guess.

simov commented 10 years ago

I haven't thought of this, I should definitely check out how SQLite engines are used in the Node world. Before that I can't say anything with certainty, but I guess it should be possible to be added.

philippwiddra commented 10 years ago

I normally use SQLite3 Package from npm.

simov commented 10 years ago

Thank you for pointing me out, I will check it out.

simov commented 10 years ago

Hi, @philippwiddra take a look at the latest release: https://github.com/simov/express-admin/releases/tag/1.2.0

I'm closing this issue for now, if you have questions don't hesitate to ask. :beer:

philippwiddra commented 10 years ago

Thank you very much, this really helps me a lot.

simov commented 10 years ago

I forgot to tell you that like with PostgreSQL you need to install the SQLite bindings separately (the module you mentioned above)

# SQLite only: run this inside the express-admin folder
$ npm install sqlite3@2.2.0

This is outlined inside the documentation as well http://simov.github.io/express-admin-site/#install and I also updated the release notes.

Other than that I found the SQLite Manager add-on for Firefox really helpful for development. Just go to Tools-Add-ons and search for sqlite manager