# Database

Concept · [Technical basics](https://ecosystem.samcarlton.com/technical)

Also called: DB, data store, data storage, SQL, tables

Organized storage for your app's information, such as users, orders and messages, so it can be saved and looked up later.

**For example:** A customer signs up today and [logs](https://ecosystem.samcarlton.com/observability) in next week. Their account is still there because it was saved in the database.

## Connects to (32)

- [Back end](https://ecosystem.samcarlton.com/back-end): The part of an app that runs out of sight on a server.
- [Authentication](https://ecosystem.samcarlton.com/authentication): Checking that a person is who they say they are, usually with a login.
- [Vector database](https://ecosystem.samcarlton.com/vector-database): A database built to store embeddings and quickly find the items closest in meaning to a question, not just the ones that share its exact…
- [Data model](https://ecosystem.samcarlton.com/data-model): The plan for what information an app stores and how the pieces relate, such as customers, orders and products and which belongs to which.
- [ORM](https://ecosystem.samcarlton.com/orm): Object-relational mapping.
- [Dashboard](https://ecosystem.samcarlton.com/dashboard): A screen that shows the important numbers for a product or a business at a glance, usually as charts and totals that update on their own.
- [Tech stack](https://ecosystem.samcarlton.com/tech-stack): The set of programming languages and tools a product is built with.
- [Backup](https://ecosystem.samcarlton.com/backup): A copy of data kept so it can be recovered if the original is lost or damaged.
- [Object storage](https://ecosystem.samcarlton.com/object-storage): A cloud service for storing files such as images, videos and documents.
- [Supabase](https://ecosystem.samcarlton.com/supabase): An open source back end platform built on the Postgres database.
- [Stateful](https://ecosystem.samcarlton.com/stateful): Describes something that carries information forward from one moment to the next.
- [Memory system](https://ecosystem.samcarlton.com/memory-system): A setup that tries to give an agent memory across sessions by saving notes to files or a database and loading them back when a new session…
- [Join table](https://ecosystem.samcarlton.com/join-table): A database table whose only job is to connect two other tables when items on each side can link to many on the other.
- [Data normalization](https://ecosystem.samcarlton.com/data-normalization): Making records consistent so the same thing is always written the same way, and, in database design, storing each fact in only one place.
- [Data warehouse](https://ecosystem.samcarlton.com/data-warehouse): A central database that collects copies of data from many business systems so it can be analyzed and reported on in one place.
- [Spreadsheet](https://ecosystem.samcarlton.com/spreadsheet): A grid of rows and columns for numbers and lists, with formulas that calculate totals.
- [Microsoft Access](https://ecosystem.samcarlton.com/microsoft-access): A desktop database app from Microsoft for building small databases with forms and reports.
- [Amazon Quick Sight](https://ecosystem.samcarlton.com/amazon-quicksight): An AWS service for building dashboards and reports from a company's data, with AI help for asking questions in plain language.
- [PostgreSQL](https://ecosystem.samcarlton.com/postgresql): A free, open-source relational database known for reliability.
- [SQLite](https://ecosystem.samcarlton.com/sqlite): A small, free database that keeps everything in a single file and runs inside the app itself, with no separate server.
- [MongoDB](https://ecosystem.samcarlton.com/mongodb): A database that stores records as flexible documents instead of rows in fixed tables.
- [Elasticsearch](https://ecosystem.samcarlton.com/elasticsearch): Software for fast searching across large amounts of text and data, from Elastic.
- [Drizzle](https://ecosystem.samcarlton.com/drizzle): An open-source TypeScript library for working with SQL databases such as PostgreSQL and SQLite.
- [Drizzle Studio](https://ecosystem.samcarlton.com/drizzle-studio): A visual browser for a database set up with Drizzle, where developers can view and edit the rows in each table.
- [Convex](https://ecosystem.samcarlton.com/convex): A hosted back end for web apps that combines a database with server functions written in TypeScript, and pushes changes to the app as they…
- [Directus](https://ecosystem.samcarlton.com/directus): An open-source tool that puts an admin app and an API on top of a SQL database, so non-developers can manage the content.
- [Cloudflare D1](https://ecosystem.samcarlton.com/cloudflare-d1): Cloudflare's managed database built on SQLite, used by apps running on Cloudflare's network.
- [ArcGIS](https://ecosystem.samcarlton.com/arcgis): Mapping and geographic data software from Esri, used by governments and companies to analyze and publish maps.
- [Codecademy](https://ecosystem.samcarlton.com/codecademy): An online platform for learning technical skills through interactive lessons, with courses in languages such as Python, JavaScript and SQL…
- [Google Data Analytics Professional Certificate](https://ecosystem.samcarlton.com/google-data-analytics-certificate): An online Google Career Certificate in data analytics, offered on Coursera.
- [Oklahoma Data & AI User Group](https://ecosystem.samcarlton.com/oklahoma-data-ai-user-group): A free, in-person Oklahoma user group for people who use data and AI in their everyday work, formerly the Oklahoma Power BI and Fabric…
- [Open Tulsa Data Portal](https://ecosystem.samcarlton.com/tulsa-open-data-portal): The City of Tulsa's portal for public data, part of its Open Tulsa transparency initiative.

Map view: https://ecosystem.samcarlton.com/database