Reviewing code was also a big bottleneck. With lot more untested code where authors don't care about reviewing their own code it will take even more toll on open source maintainers. Code quality between side projects and open source projects are different. Ensuring good code quality enables long term maintenance for open source projects that have to support the feature through the years as a compatibility promise.
I used rewriting as a learning experience. I found flutter to be simpler with respect to UI and state management compared to using XML by default for UI. Since mine was a crud app flutter was okay. I later found jetpack compose which has flutter like UI composition and I liked it better since I can access the existing Android library ecosystem too.
I too wrote a similar app for my personal problem and also served to be a good way to learn about kotlin and Android ecosystem. I also tried a rewrite in flutter and compose. The idea was to use select the word and then click meaning from context menu so that meaning occurs as notification and disappears in 15 seconds. I used Wiktionary as dataset source and app works offline.
In case of PostgreSQL there is json and jsonb. For SQLite, hexdump of the database shows text representation and seems to be stored like json than jsonb. I am not aware of the full design and source code but it seems some functions parse and cache the JSON representation.
> The json and jsonb data types accept almost identical sets of values as input. The major practical difference is one of efficiency. The json data type stores an exact copy of the input text, which processing functions must reparse on each execution; while jsonb data is stored in a decomposed binary format that makes it slightly slower to input due to added conversion overhead, but significantly faster to process, since no reparsing is needed. jsonb also supports indexing, which can be a significant advantage.
It seems readfile is from an extension but present in cli. json_each is present in standard sqlite core from 3.38.0 as json1 extension is also now part of core.
> Note that the readfile(X) and writefile(X,Y) functions are extension functions and are not built into the core SQLite library. These routines are available as a loadable extension in the ext/misc/fileio.c source file in the SQLite source code repositories.
https://ziggit.dev/t/bun-s-zig-fork-got-4x-faster-compilatio...