Seven essential database schema best practices
Your database schema is the foundation for everything you do with data. Learn our essential best practices in our complete guide.
Your database schema is the foundation for everything you do with data. Learn our essential best practices in our complete guide.
Getting data *into* your database is easy, but querying large datasets is challenging—especially without the right indexes. Pavel Tkachenko teaches how to write performant SQL queries with EXPLAIN and ANALYZE.
Learn how Fivetran is addressing your high-volume database replication needs with our newest High Volume Agent connector for SQL Server.
Choosing the right tool for a web application can be tricky. But if you do, it will make things a lot easier for you. Depending on your application, combining Node.js and MongoDB works well most of the time — especially if you use a front-end framework like React (MERN), Angular (MEAN), or Vue (MEVN). In this tutorial, you will learn how to create a CRUD application using Node.js and MongoDB and write some basic tests for your Node.js API.
Today, non-relational, schemaless data models dominate the domain of databases. Non-relational databases are more developer-friendly and scale better than the relational databases of the past. However, it is harder for them to do complex tasks. Now we have a new player in the game to address this issue: EdgeDB. EdgeDB is built on top of PostgreSQL and introduces a new conceptual model for representing data.
With Fivetran’s teleport sync, you can quickly replicate database changes with just a read-only user.
Our new feature helps you implement Type 2 slowly changing dimensions for your historical database analytics with no coding needed.