Backend SQLite

[vincent-herlemont]

Would it seem possible to have SQLite as the backend instead of Rockdb, mem etc.?

Here she points why:

Advantage:

• Compatible with almost all platforms.
• Benefit from the surrealdb developer language for SQLite.
• Software that already uses SQLite can be compatible without changing anything.

Inconvenience

• Performance maybe?

[finnbear]

Software that already uses SQLite can be compatible without changing anything.

SurrealDB implements a relational/document/graph database on top of a key-value store. Are you suggesting that SQLite (a relational database) would be used as a key value store e.g. with a single SQLite table associating keys and values? Or are you suggesting that SurQL queries be compatible with existing SQLite tables?

[vincent-herlemont]

@finnbear I suggest that SurDB use SQLite for key value store.