4 ms·
I am amused by the number written by Dr. Hipp. I appreciate his desire to keep core small and stable, but some of these would be great to get promoted into the
by fbdab103 3y ago
I am amused by the number written by Dr. Hipp. I appreciate his desire to keep core small and stable, but some of these would be great to get promoted into the base package.
News to me, there is a Python package[0], sqlean-py, which makes it trivial to bring in these extensions.
[0] https://antonz.org/sqlean-py/ https://antonz.org/sqlean-py/
- nalgeon 3y agoSometimes they do! The `unhex` function, for example, has finally made it's way into the core function set. So did `json1`. Some text functions like `trim` have been added recently, and there will even be a (long-awaited) `timediff` function in the next release.
- fbdab103 3y agoOh no doubt, things are always improving. While I have not yet used it, happy for the recent json enhancements (personally, I would always prenormalize to standard JSON instead of naively ingesting JSON5). Datetime is definitely one of my SQLite sore spots, so happy to see improvements there. I have to consult the docs + experimentation every time I need to do something with time manipulation. Even then, I usually left a bit disappointed with the available functionality.