Recent posts tagged database

joente Dec 22, 2025 in Articles 3 min read
In my previous posthttps://coderlegion.com/8421/schema-first-approach-with-thingsdb, I promised to dive into the client side. However, to truly appreciate how the client interacts with the system, we first need to pull back the curtain on what happen...
post-cover-8731
joente Dec 12, 2025 in Articles 4 min read
In many architectures, the separation between database and application code introduces a dangerous gap where data integrity can fail. The application code is responsible for validation, but what if multiple services access the same data? This post e...
post-cover-8421
joente Dec 10, 2025 in Articles 2 min read
"No code in the database" is a mantra instilled in developers from computer science school onward. It's a fundamental principle of traditional database design aimed at separation of concerns and maintainability. But what if your database IS your cod...
Theodora.dev Nov 19, 2025 in Articles 7 min read
Intro Hey everyone! If you are a developer who is just starting to work with databases, or perhaps you already know the basics and are looking for a recap or a more in-deph understanding, I hope this article will help you. When I learn something new...
post-cover-7513
David Lopez Felguera Sep 30, 2025 in Articles 10 min read
As is tradition around this time of year, the global PostgreSQL community has surprised us with a new major version, and this time is no exception. On September 25th, the PostgreSQL Global Development Grouphttps://www.postgresql.org/ officially relea...
horushe Sep 21, 2025 in Articles 9 min read
How to architect robust database schemas that power modern AI applications with credit systems, multi-provider authentication, and user-generated content at scale The Challenge Building AI applications requires rethinking traditional database desig...
Tom Smith Sep 8, 2025 in Articles 2 min read
RavenDB Cuts AI Agent Development from Months to Days with Database-Native Solution Enterprise AI projects have a problem. While consumers can plan meals or design trips with ChatGPT in seconds, businesses still rely on rigid chatbots that can't ac...
Derrick Ryan Aug 25, 2025 in Articles 4 min read
Oracle Exadata Database Service represents the pinnacle of enterprise database technology in the cloud, combining the raw power of purpose-built Exadata hardware with the flexibility and scalability of cloud infrastructure. This service enables org...
post-cover-4999
Vignesh J Aug 23, 2025 in Articles 8 min read
SQL or NoSQL - the debate isn’t just about databases, it’s about how your application will think, grow, and scale. > Pick the wrong one, and you might end up fighting your database instead of building your product. !database Ragehttps://media2.giph...
post-cover-4923
Derrick Ryan Aug 21, 2025 in Articles 4 min read
Oracle Base Database Service: Your Gateway to Full Database Control in the Cloud As developers increasingly move their workloads to the cloud, finding the right balance between managed services and control remains a challenge. Oracle's Base Databas...
Joonatan Uusväli Aug 17, 2025 in Articles 4 min read
Choosing the right unique identifier in a distributed system can feel like a minor detail, but it has massive consequences for database performance, scalability, and even how quickly you can debug a production incident. For years, we've reached for U...
freederia Aug 7, 2025 in Articles 11 min read
Hyper-Relational Embedding Space Mapping: Unifying Neural Representation and Olfactory Receptor Dynamics in Transformer Models Abstract: Transformer models have demonstrated remarkable proficiency in natural language processing and increasingly in do...
Joonatan Uusväli Aug 6, 2025 in Articles 2 min read
Unique identifiers are the backbone of data management, distributed systems, and secure API design. While UUIDs UUIDv4 and integer IDs are widely used, ULIDs Universally Unique Lexicographically Sortable Identifiers are emerging as a superior choice ...
post-cover-4482
Joonatan Uusväli Jul 14, 2025 in Articles 3 min read
Choosing the right identifier scheme is crucial in the sprawling landscape of software development. It impacts performance, scalability, and reliability, whether you're architecting a database, an API, or a distributed system. While auto-incrementing...
post-cover-3984
Abdelhakim Baalla Jul 10, 2025 in Tutorials 7 min read
Follow Me for More Content! Before we dive into SQL, let's connect! Follow me on these platforms for more programming tutorials and tech insights: GitHub: Abdelhakim-Baallahttps://github.com/Abdelhakim-Baalla - Check out my projects and code Link...
Tom Smith Jul 8, 2025 in Articles 5 min read
Oracle and AWS Just Shocked the Tech World by Becoming Partners Here's why their database alliance changes everything. The tech industry has witnessed numerous surprising partnerships over the years, but few have been as jaw-dropping as Oracle an...
post-cover-3834
Methodox Jun 24, 2025 in Articles 4 min read
SQLite SQLite is a self-contained, serverless, zero-configuration relational database engine. Unlike traditional database servers, SQLite is distributed as a simple library that you embed directly into your applications. This guide will introduce y...
Methodox Jun 2, 2025 in Articles 9 min read
SQL - A Quick Intro Overview In this article, we’ll walk through the essentials of SQL using the SQLite dialect. We’ll start by creating a couple of sample tables and populating them with data. These tables will serve as the foundation for our exa...
Methodox May 23, 2025 in Articles 4 min read
The Authentication Problem Let's face it: develop a custom authentication service is conceptually straightforward but practically troublesome. You either allow user registration or not, then authenticate by taking a look at username and password li...
Methodox May 20, 2025 in Articles 3 min read
Overview For an internal database, we needed to implement some sort of text-based search capabilities to help users locate documents. One goal was to be lightweight, hassle-free, easy to set up, expand, and maintain—and ideally, to set it up once a...
chevron_left

Active Discussions

New

Vardan
Leandro Junior Alves dos Santos
elsieraine_x

Featured

Methodox
Steve Fenton
Trent Polack