byteNative
Languages

SQL

Precise queries and modelling of relational databases.

What is SQL?

SQL is the language we use to model relational data and query it precisely. Instead of describing step by step how something is fetched, you state what you want and the database finds the best way there. It can look unassuming at first glance, yet a well-considered data model and carefully written queries often decide whether an application runs smoothly or starts to stutter. That is why we treat the data layer with the same care as the visible part of a solution.

How we use it

We use SQL in practically every project with a relational database, whether directly or through an ORM like Prisma. For tricky analyses and reports we deliberately write the queries by hand, because that is where the most speed can be gained. A well-considered schema saves us many special cases later.

sql
SELECT c.name, COUNT(o.id) AS orders
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id
GROUP BY c.name
ORDER BY orders DESC;
a join with grouping answers orders per customer

Good to know

When a query is slow, look at its execution plan instead of adding indexes blindly. More often than not, a sluggish page comes down to a single missing index on a column that is frequently filtered or joined on.

00Languages

More tools we work with in the same area.

Which technology fits you?

You don't have to decide that, it's our job. Tell us about your plans.