Building our Database Connection Guide using Next.js
We produced a fast-loading site wiki site with little code in a short time frame using 3 Next.js features.
5 months ago
Articles
How to secure data using stored procedures in SQL
A stored procedure is a set of SQL statements with an assigned name, which can be stored for later use so it can be reused and shared by multiple programs. Stored procedures also allow admins to apply permissions to users.
By
Bonnie
Need a UUID generator for Postgres? Here are two ways to set one up.
In this article, you'll learn about Postgres UUIDs and how to generate them with examples from two different modules.
6 months ago
Choose the Right Model: Comparing Relational, Document, and Graph Databases
There are 3 major types of database models in use today. Learn about their differences and what applications they are good for.
6 months ago
Using cursors and for loops in MySQL
If you've ever wanted to learn how to write a MySQL cursor or a MySQL loop, you've come to the right place. Let's iterate!
6 months ago
SQL
public
Understanding SQL Dialects
There are numerous SQL dialects instead of one fully implemented SQL standard. In this post we learn about the major ones. Plus lists of all of them.
6 months ago
Querying Shopify Data in Postgres
How to extract data from your Shopify store, load it into Postgres, and query it for more meaningful insights on your store's performance.
6 months ago
Our Journey with IndexedDB
By upgrading to IndexedDB as the local data store, developers can export unlimited data from Arctype, get faster results from queries, and see much less memory consumption from the app. This is the story of our implementation
6 months ago