Playlist · 6 videos · 37 min
Databases, schemas and relations
Connect MongoDB, MySQL, MariaDB, PostgreSQL, SQL Server and Oracle; create databases and tables in the panel; vectors, JSON, bytes, shapes and intervals as plain JSON; schemas checked on every write; encryption, ids and concurrency; relations across engines and the ER diagram.
The videos of this playlist
5:461. DatabasesConnect 6 Databases and Get REST APIs for Every Table
Connect MongoDB, MySQL, MariaDB, PostgreSQL, SQL Server and Oracle to one API Maker backend. Connection strings stay in a secret on the server, every instance is tested before it is saved, and every table answers REST APIs without a line of code.
11:062. Table designerCreate Databases and Tables in the Panel: One Designer, Six Engines
Make databases and tables on MongoDB, MySQL, MariaDB, PostgreSQL, SQL Server and Oracle right in the API Maker panel. Design column by column, read the statements written for your engine before they run, run scripts of your own, edit tables as ALTER statements, and keep the schemas of API Maker in step, both ways.
5:083. Data typesVectors, JSON, Bytes, Shapes and Intervals Through One REST API, on Six Databases
Every column type of MongoDB, MySQL, MariaDB, PostgreSQL, SQL Server and Oracle goes through the same APIs as plain JSON: AI embeddings as lists of numbers, JSON as JSON, bytes as one Buffer object, shapes as GeoJSON, intervals as objects. Shown on MariaDB 12.1 vectors, MongoDB BSON vectors and PostgreSQL.
5:434. SchemasTable Schemas in TypeScript, Checked on Every Write
In API Maker, the schema of a table is TypeScript written from the real table, kept in Git, and checked by the server on every write, whoever writes. Follow the rules of the support tickets of Calm Home: validations and conversions, nested objects and arrays, vectors and JSON, invented keys refused, and a schema compared with its table.
5:345. Data safetyEncrypted and Hashed Fields, Auto Increment and Optimistic Locking
Encryption, hashing, auto increment numbers, generated ids and updates that never erase each other: in API Maker each one is a key in the schema of a table, on MongoDB as on SQL. See what the database really holds, how your code reads it back with the secret, and how a stale update is refused.
4:076. ER diagramRelations Across Databases and the ER Diagram
A few keys in a schema link two tables, whatever their engines: the shipments of the warehouse meet the orders of the shop. Typos are caught when the schema is saved, and deep populate, find and join, master save and the ER diagram all follow the relation.