search

nalgeon / sqlean

The ultimate set of SQLite extensions
MIT License
3.67k stars 117 forks source link

Non-Unicode SQLite #44

Closed zzo38 closed 2 years ago

zzo38 commented 2 years ago

Would patches to SQLite be possible, too? Many things are possible by extensions but some things may need patching the code of SQLite itself, too, or are working better by patches. One patch is below but others are also possible too.

I made up a patch to improve SQLite by excluding the Unicode capabilities. (Hopefully can also be tested if combined with other patches too.)

zzo38 commented 2 years ago

The insistence of using Unicode is a design flaw; that is why I implemented a patch to try to avoid the use of Unicode as much as possible. I think that %!s is not actually that useful anyways, but it is kept in there for compatibility purpose, since it does not interfere with the attempt to use non-Unicode text (you can use %s instead). (I may change this to remove this Unicode capability too, but currently it isn't.)

nalgeon commented 2 years ago

Sorry, I have no plans to patch SQLite. This project is dedicated to extensions.

zzo38 commented 2 years ago

OK, that is reasonably enough. (I have my own repository for patches, and would like to see others contribute proposals and patches and other information there, too. I have started writing and intend to soon commit some changes with some further documents, too. I may also add extensions as well as patches in future, too.)