ChartDB – Free and open source, database design editor

Re:ChartDB – Free and open source, database design editor by lfmunoz4 on Wednesday August 28, 2024 @11:13AM (#41380429)

data types seem wrong, ie. sqlite doesn't have smallint right?

[ Parent | on HN ]

Re:ChartDB – Free and open source, database design editor by cristoperb on Wednesday August 28, 2024 @11:25AM (#41380554)

sqlite does recognize the SMALLINT keyword and treats it as an INTEGER (sqlite only has two number types, integer and real). See here under "Type Affinity": https://www.sqlite.org/datatype3.html

[ Parent | on HN ]