Posts tagged "database"

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

Vector embeddings made easy with Go, Azure Cosmos DB, and OpenAI

When working on applications that need vector/semantic/similarity search, it's often useful to have a quick and easy way to create vector embeddings of data and save them in a vector database for furt...

21.04.2025 0 Read More

Database Normalization Summary

Normalization The process of structuring data in a way to curb redundancy and ensure data integrity 1NF Using row order to convey information violates 1NF, e.g., arranging numbers fr...

21.04.2025 0 Read More

Indexing in PostgreSQL: Pros, Cons, and Best Practices

Indexing is a fundamental feature in PostgreSQL that can significantly enhance query performance. However, while indexes can speed up data retrieval, they come with trade-offs. This article explores t...

21.04.2025 0 Read More

Turbocharge Your Rails Apps with Smart Database Indexing

Is your Rails application running slow? Are search queries taking forever to complete? The solution might be simpler than you think. Proper database indexing can dramatically improve search and filter...

21.04.2025 0 Read More

🌙 Daily MySQL Backup (Windows)

🧾 What It Does 📦 Exports your MySQL database to a .sql file 🕒 Runs automatically every day 🧹 Deletes old backups after 7 days (optional) 📁 Folder Setup Create this fold...

21.04.2025 0 Read More

Spinning Up PostgreSQL with Docker Compose + Dashboard

Hello, database lovers! (I know that doesn’t really exist, but hey — I'm trying to break the ice here 🫠)I want to share a script to spin up PostgreSQL using docker-compose, which can be useful ...

21.04.2025 0 Read More

Help Build Doguino – A Dutch Online Dog Game

🚀 Help Build Doguino – A Dutch Online Dog Game Full of Charm and Strategy! Hi everyone! 👋I'm Vincent, and I'm passionately working on a browser-based game called Doguino – a Dutch online dog...

21.04.2025 0 Read More

How to count 100B events: Comparing architectures

In the previous posts, we looked at how to build, optimize, and scale a simple view counter service to be able to handle 100B+ views and a high-cardinality of unique viewers. These posts were inspired...

21.04.2025 0 Read More

Optimizing ClickHouse for Financial Time Series

Our product, https://marketlens.app, is a market visualization tool that receives data from exchanges’ WebSockets. Top exchanges produce gigabytes of data daily. For instance, Binance ETH/USDT perpe...

21.04.2025 0 Read More

Deduplicate between an Uncertain Number of Columns — From SQL to SPL #21

Problem description & analysis: A certain database table has multiple fields, each storing an email address, which may be null or duplicated.Task: Now we need to merge multiple fields int...

21.04.2025 0 Read More

Vector embeddings made easy with Go, Azure Cosmos DB, and OpenAI

Database Normalization Summary

Indexing in PostgreSQL: Pros, Cons, and Best Practices

Turbocharge Your Rails Apps with Smart Database Indexing

🌙 Daily MySQL Backup (Windows)

Spinning Up PostgreSQL with Docker Compose + Dashboard

Help Build Doguino – A Dutch Online Dog Game

How to count 100B events: Comparing architectures

Optimizing ClickHouse for Financial Time Series

Deduplicate between an Uncertain Number of Columns — From SQL to SPL #21

#reading

#popular