HN user

xtreak29

633 karma
Posts21
Comments70
View on HN
tirkarthi.github.io 5mo ago

AI usage in popular open source projects

xtreak29
1pts0
tirkarthi.github.io 11mo ago

Generative AI and Healthy Skepticism

xtreak29
1pts2
airflow.apache.org 1y ago

Apache Airflow 3.0 Release

xtreak29
19pts2
airflow.apache.org 1y ago

Apache Airflow 2.10.0 is here

xtreak29
1pts0
airflow.apache.org 2y ago

Apache Airflow 2.9.0 Release

xtreak29
2pts0
play.google.com 2y ago

Show HN: An open source dictionary app to show meanings as notifications

xtreak29
2pts0
tirkarthi.github.io 4y ago

New JSON query operators in SQLite 3.38.0

xtreak29
397pts33
play.google.com 4y ago

Show HN: An open source offline dictionary based on notifications

xtreak29
5pts0
twitter.com 5y ago

PEP 657: Fine grained locations in tracebacks merged to Python 3.11

xtreak29
1pts0
tirkarthi.github.io 6y ago

Python 3.9 and beyond backwards compatibility

xtreak29
4pts0
github.com 6y ago

Rich Hickey GitHub Sponsorship

xtreak29
2pts0
tirkarthi.github.io 6y ago

Finding Balance in Open Source

xtreak29
10pts0
tirkarthi.github.io 7y ago

PEP 578 – Runtime audit hooks in Python 3.8 improving security and transparency

xtreak29
2pts0
tirkarthi.github.io 7y ago

F-string debugging notation merged in Python 3.8

xtreak29
2pts0
discuss.python.org 7y ago

Python governance vote results

xtreak29
5pts1
tirkarthi.github.io 7y ago

Stream processing with Redis streams and Clojure

xtreak29
3pts0
tirkarthi.github.io 7y ago

Type annotations in Python's error messages

xtreak29
1pts1
tirkarthi.github.io 8y ago

Analyzing 30k issues in bugs.python.org

xtreak29
2pts0
blog.travis-ci.com 8y ago

Post-Mortem and Security Advisory: Data Exposure After travis-ci.com Outage

xtreak29
351pts169
github.com 8y ago

Show HN: Clj-wordcloud – A Clojure library to create word clouds

xtreak29
1pts0
tirkarthi.github.io 8y ago

Data mining clojars.org for JDK 9 and Clojure 1.9 issues

xtreak29
2pts0

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.

https://play.google.com/store/apps/details?id=com.xtreak.not...

https://github.com/tirkarthi/NotificationDictionary

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.

https://github.com/sqlite/sqlite/blob/a0318fd7b4fbedbce74f13...

https://www.postgresql.org/docs/current/datatype-json.html

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.

json_each : https://www.sqlite.org/json1.html#jeach

readfile : https://sqlite.org/cli.html#file_i_o_functions

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.

There are couple of threads related to json import but a default mode will be helpful as there is already .mode json for output and import support will be great.

https://sqlite.org/forum/forumpost/567caa57234b98e46b885bcf8...

https://sqlite.org/forum/forumpost/f4b44e09cea20851014420a8b...

sqlite-utils is also a helpful project for various utilities : https://sqlite.org/forum/forumpost/ff5b6198eb6e794d2f774ce06...

I guess you are trying to do below from your comment.

  $ echo '["Kate", "John", "Jim"]' > names.json
  $ ./sqlite3
  SQLite version 3.38.0 2022-02-22 18:58:40
  Enter ".help" for usage hints.
  Connected to a transient in-memory database.
  Use ".open FILENAME" to reopen on a persistent database.
  sqlite> create table users(id integer primary key, name text);
  sqlite> insert into users(name) select value from json_each(readfile('names.json'));
  sqlite> select * from users;
  1|Kate
  2|John
  3|Jim
IPython 8.0 5 years ago

Thanks for the release. I just upgraded and error messages are really nice. One bit I might be missing is that Python 3.10 added suggestions for AttributeError and NameError. It seems the suggestions are not stored in the exception object but calculated when Error is displayed. There is a note that that this won't work with IPython but it will be good to check if it's feasible.

https://bugs.python.org/issue38530 https://docs.python.org/3/whatsnew/3.10.html#attributeerrors