Arctype is a free, collaborative SQL editor for developers. Join our newsletter to receive unique stories from developers about programing and databases.
A Powerful Addition to Your Postgres Toolbelt: Table Inheritance
Learn how to use inheritance in your Postgres database to save time and effort with data management.
6 Common Mistakes for SQL Queries that "Should be Working"
We've all seen the dreaded error... SQL: Invalid syntax near ")". In this article, I cover some of common culprits I've seen for this error and others.
Time to Add Databases to your Spring Cleaning - VACUUMs in Postgres
Deleted records from your database could still be taking up space on your disk. Learn how to use VACUUM to reduce size and improve performance of your databases.
Create a Web App and Deploy it to the Cloud in 20 minutes with Python
Learn how to create a web app using Flask, connect to a Postgres database, and deploy the app and database to Heroku.
Forget SQL vs NoSQL - Get the Best of Both Worlds with JSON in PostgreSQL
Create a database schema for any situation with the power of JSON.
Slow Queries? 10X Query Performance with a Database Index
Database indexes are a common solution for faster queries, but they also add overhead that can degrade performance. Keep reading to learn how to create the optimal database index.
How Divided Are We? Top 20 Words in Biden's vs Trump's Inauguration Speeches
50% of the top 10 words in Biden's inaugural speech were the same as Trump's top 10 words. Analyze both inaugural speeches with Python to find all the similarities and differences.