1,045 karma · joined September 22, 2014
> Announcing Discovery Loop!
> I am very excited to announce that, along with my longtime friends and collaborators @Sanjay_Ghemawat, @OriolVinyalsML and @quocleix, we are founding Discovery Loop (@DiscoLoopAI), a Public Benefit Corporation whose mission is to automate machine learning, science, and engineering to accelerate discoveries and progress. The four of us have worked together for 14 to 30 years, and have helped build some of the world’s most used products, infrastructure and AI models, and we’re excited to turn our attention to this ambitious endeavor.
https://ziggit.dev/t/bun-s-zig-fork-got-4x-faster-compilatio...
https://play.google.com/store/apps/details?id=com.xtreak.not...
https://dev.to/danielgtaylor/a-cli-for-rest-apis-part-1-104b https://github.com/danielgtaylor/restish https://github.com/danielgtaylor/openapi-cli-generator https://github.com/OpenAPITools/openapi-generator
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.
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.
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|Jimhttps://bugs.python.org/issue38530 https://docs.python.org/3/whatsnew/3.10.html#attributeerrors