DEV Community

loading...

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

patarapolw profile image Pacharapol Withayasakpunt ・1 min read

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?

Discussion

pic
Editor guide