SQL Basics with SQLite and PostgreSQL (Questions) — Flashcards | Databases | FatSkills

SQL Basics with SQLite and PostgreSQL (Questions) — Flashcards

Fast review mode: answers are shown by default so you can skim quickly. Hide them if you want to self-test.

SQLite is an Embedded DBMS. This means that it is a Serverless DBMS with the ability to run within your applications.

PostgreSQL DBMS implements a Client-Server Model and requires a Database Server to set up and run over a network.

SQLite vs PostgreSQL: SQLite is very fast, thanks to its minimal design and simple operations. SQLite is for you if all you require is fast read operations. PostgreSQL is more suitable for complex operations.

1 of 189 Ready
What does SQL stand for?
Structured Query Language
Shortcuts
Prev Space Show / hide Next
Turn this into a study set.
Sign in with Google to save tricky questions to your reminder list and resume on any device.
Sign in with Google Free • no extra password