Browsing Tag
database
141 posts
Uses of SQLite
When people ask me where SQLite actually fits into the real world, I usually tell them the honest…
SQLite Embedded Device Support
When I first started tinkering with embedded systems as part of my broader interest in low-level programming, I…
SQLite Unique Features
The more time I’ve spent working with SQLite, the more I’ve come to appreciate that it isn’t just…
What Is SQLite?
When I first heard the name “SQLite,” I honestly assumed it was some kind of trimmed-down toy database…
Become a SQLite master
I’ve spent a long time working with SQLite across mobile-style prototypes, embedded logging systems, command-line tools, and quick…
How to Insert Data into a Table in PostgreSQL
Once you’ve got a table built, the next step is putting actual data into it. PostgreSQL’s INSERT statement…
How to Drop a Table in PostgreSQL
At some point in nearly every project, you’ll need to remove a table entirely — maybe it was…
How to Create a Table in PostgreSQL
Tables are where the actual work happens in any relational database — they’re the structures that hold your…
How to Drop a Database in PostgreSQL
Dropping a database is one of those commands that looks deceptively simple but deserves real caution — it…
How to Create a Database in PostgreSQL
Once PostgreSQL is installed and running, the very first real task is creating a database. Everything in PostgreSQL…