CODEWITHSUNDEEP
javascriptdatabasememory
Tom
Tom

Reputation: 3637

Create database in memory from sql/csv files in Javascript

I am creating a product that as end result will/can create e.g. 10 .sql files, each being a table. The tables will contain various pre-calculated data related to each other.

My users will need to upload these to their website (php, asp, whatever) and will need to make something useful. Only problem, the users may have next to zero understanding of databases, server-side code etc. This means it must be very easy to configure.

So I think thinking upload these .sql (or CSV files, whatever) tables to server, so they are publicly available (i.e. can be retrieved like any other public URL). And then find a Javascript in-memory database engine that can load .sql database files. Does this exist?

I imagine a Javascript solution could work well if amount of data could be kept somewhat down... Otherwise I may need to look for a PHP/ASP solution as well. (Any ideas for libraries that can init in-memory databases from .sql or similar files?)

Preferably I should be able to re-distribute this Javascript library. (So users can get a complete "directory" of .sql files + example page + Javascript database engine to upload)

So to make the question clear: Anyone knows a Javascript-based in-memory database engine that can run inside browser?

Upvotes: 3

Views: 4003

Answers (5)

Gyum Fox
Gyum Fox

Reputation: 3627

That question seems very old. You might want to look at LokiJS now.

Upvotes: -1

hdx
hdx

Reputation: 4548

http://diveintohtml5.ep.io/storage.html might be what you are looking for.

Upvotes: 0

Nilloc
Nilloc

Reputation: 875

Here's a pure JS SQL engine that stores everything in memory, https://github.com/moxley/sqittle

It flatly denies being useful for anything though, and has a limited set of supported commands (see readme on above link.

Upvotes: 1

dmidz
dmidz

Reputation: 896

If you wish to use javascript and need some 'userfriendly' bridge database, you could use json or xml, because the format are simple text files (like csv as well) for wich you can find smart small editors for your users. More json is made for javascript parsing and has an understanding tree format, but you should load only some part of sql datas in memory, saying data buffers in xml or json, with php requested with some javascript ajax call. Php do the sql database access work and then you can output json, and with javascript, it is for user's interface, you'll be able to display them.

Upvotes: 1

Baversjo
Baversjo

Reputation: 3716

You can use mysql to store a database in memory:

http://dev.mysql.com/doc/refman/5.0/en/memory-storage-engine.html

Upvotes: 1

Related Questions