2 forum posts by user mattkuine
|12:43||• Reply: Error: near line 1: no such module: fts5 (artifact: 9b0a4b210c user: mattkuine)|
Post: Lack of abstraction ability in SQLite
(artifact: 1042988a22 user: mattkuine)
SQLite's query language is so powerful it's even Turing-complete with recursive common table expressions. However it's completely lacking in abstraction power.
The C API is lacking as well:
I think adding these features to SQLite, which is already modular by design, isn't difficult. SQLite already implements many programming features such as streaming logic, relational logic, authorization, table-valued functions, etc. and I think it can be made into a general-purpose, multi-paradigm (stack based, functional, logic, procedural, object-oriented, etc.) programming environment and operating system for developing portable applications that run anywhere if these features are added.
SQLite is a modular, well-designed, extensible data storage and processing library and if it is a little bit more modular and extensible it would take over the world.