Below you will find pages that utilize the taxonomy term “SQL”
From dbf to SQL (and PostgreSQL) with Python
Some time ago I found an interesting database file suffix I never faced before: the .dbf
and saw around that it was first introduced in 1983 with dBASE II. This article showcases how we can automatically generate the PostgreSQL table and fill it with data using Python and dbfread.
11 Lessons to learn when using NULLs in PostgreSQL®
A boolean value should only contain two values, True
or False
, but is it correct? Usually people assume so, but sometimes miss the fact that there could be the absence of the value all-together. In databases this is absence is usually stored as NULL
and this blog showcases how to find them, use them properly and 11 lessons to learn to be a NULL
Pro!
Keep in mind, it’s not only booleans that can contain
NULL
values, it’s all the columns where you don’t define aNOT NULL
constraint!