New

The latest blog posts to take off on Hacker News. 1,517 posts.

Software Engineering
2021
612

SQLite Is Dynamically Typed (2020)

A small, cool fact about SQLite is that its columns are flexibly typed. You can store any value in any column! Try it out: sqlite> create table t1 (v1 int, v2 varchar(10)); sqlite> insert into t1 values ("abc", "this string is longer than 10 characters!"); sqlite> select * from t1; abc|this string is longer than 10…