Custom SQLite that did exactly what creator wanted? (Beyond default drivers, e.g. extensions / custom build)

#sql #discuss #sqlite

So far, I have seen two things.

Extensions. Most common one is probably REGEXP.
Custom collations. Recently, I saw UNICASE, which is probably some kind of ASCII-based unicode normalization.

I have never tried SQLCypher or auths, and I don't get yet why I would use it.

In a language, there are probably also alternative drivers, beyond the default ones as well; at least in Python and Node.js. Also, JDBC-interface (i.e. Java driver) can also be used in both languages.

Closest I have to writing C code is writing cgo. But I don't know to write Rust, or real C/C++ code.

I see that custom built SQLite driver is also possible. But, it would hinder using DB Browser for SQLite, or reverse-engineering?

Top comments (0)

The Open Source Revolution: Empowering Developers Through GitHub Sponsors

Laetitia Perraut - Mar 4

Blockchain and Open Source: A New Dawn of Innovation

Bob Cars(on) - Mar 4

Revolutionizing Email: Stalwart Mail Server - Secure, Modern, and Easy to Use

GitHubOpenSource - Mar 4

Elon Musk and Open Source: Redefining Innovation Through Collaboration

ashu-commits - Mar 4

Try REST API Generation for MS SQL Server.

DreamFactory generates live REST APIs from database schemas with standardized endpoints for tables, views, and procedures in OpenAPI format. We support on-prem deployment with firewall security and include RBAC for secure, granular security controls.

See more!

DEV Community