PostgreSQL

Showing 1-7 of 7 results
EngineeringIcon ChevronBack-end

Solving Bottlenecks With SQL Indexes and Partitions

By Mirko Marović

Indexes and partitioning can help with SQL performance, but they're not cure-alls. Through everyday examples of date range and LIKE queries, find out how to "think like an RDBMS" to make yours run faster.

14 minute readContinue Reading
EngineeringIcon ChevronBack-end

SQL Indexes Explained, Pt. 2

By Mirko Marović

Sorting a table can make some queries faster—but the maintenance cost is untenable. Enter real database indexes and their most common implementation structure: the B-tree.

10 minute readContinue Reading
EngineeringIcon ChevronBack-end

SQL Indexes Explained, Pt. 1

By Mirko Marović

Properly used, an SQL database index can be so effective that it might seem like magic. But the following series of exercises will show that underneath, the logic of most SQL indexes---and wielding them correctly---is quite straightforward.

8 minute readContinue Reading
EngineeringIcon ChevronBack-end

Timestamp Truncation: A Ruby on Rails ActiveRecord Tale

By Maciek Rząsa

Tests should keep apps from being flaky. But tests themselves can become flaky—even the most straightforward ones. Here's how we dove into a problematic test on a PostgreSQL-backed Rails app, and what we uncovered.

< 5 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

Developing a Bioinformatics Database for Disulfide Bonds Research

By Viktor Bojović

The Protein Data Bank (PDB) bioinformatics database is the world's largest repository of experimentally-determined structures of proteins, nucleic acids, and complex assemblies. All data is gathered using experimental methods such as X-ray, spectroscopy, crystallography, NMR, etc. This article explains how to extract, filter, and clean data from the PDB to make it suitable for further analysis.

25 minute readContinue Reading
EngineeringIcon ChevronTechnology

Database Design Bad Practices: Are You Making These Mistakes?

By Fernando Martinez

Flaws in your database design are like cracks in your application’s foundations. If left unchecked, trying to fix them down the line will be costly to say the least. In this article, Toptal Freelance Software Engineer Fernando Martinez discusses some of the most common database design bad practices and how to avoid them.

8 minute readContinue Reading
EngineeringIcon ChevronBack-end

Meet Ecto, No-compromise Database Wrapper for Concurrent Elixir Apps

By Boris Barroso

Elixir, with its simple and clean syntax, makes building scalable and maintainable concurrent applications a breeze. Ecto is a database wrapper that lives up to the high expectations set by Elixir's reputation. Its domain-specific language provides a pleasant way to interact with databases and build fault-tolerant, concurrent applications in Elixir with ease. In this article, Toptal Freelance Software Engineer Boris Barroso walks us through Ecto and its four main components: Repo, Schema, Changeset, and Query.

17 minute readContinue Reading

Join the Toptal® community.