New

The latest blog posts to take off on Hacker News. 14,541 posts.

Software Engineering
Any year
5887

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…