database

Recent in

database

Kubernetes-Native Database: TiDB Vs.
kubernetes

Kubernetes-Native Database: TiDB Vs.

https://hackernoon.com

A new generation of “Kubernetes native’ databases have been designed from the ground up to run on the open-source orchestration system.

DataStaxFeb 28, 2023
How to Improve Query Speed to Make the Most out of Your Data
data-science

How to Improve Query Speed to Make the Most out of Your Data

https://hackernoon.com

The world is getting more and more value out of data, as exemplified by the currently much-talked-about ChatGPT, which I believe is a robotic data analyst. However, in today's era, what's more important than the data itself is the ability to locate your wanted information among all the overflowing data quickly.

Junfei LiuFeb 23, 2023
4 Data Transformations Made Spreadsheet-Easy
data

4 Data Transformations Made Spreadsheet-Easy

https://hackernoon.com

Big Data solutions are becoming increasingly complex as data teams get more sophisticated. Without prior coding or database experience, many find these highly technical tools overwhelming.

GigasheetFeb 20, 2023
Unexpected Discoveries in TypeORM 0.3.11
database

Unexpected Discoveries in TypeORM 0.3.11

https://hackernoon.com

This article is about an unexpected discovery made while working with TypeORM, an Object-Relational Mapping (ORM) tool that is designed to work with TypeScript. The author upgraded the project to the latest version 0.3.11 and found some incompatible changes that they liked, some they were okay with, and others they didn't like. One of the things they liked was that the .findOne() or findOneBy() methods will no longer return undefined, instead they will return null. One of the things they were okay with was the new version's stricter requirement to pass the whole FindOptions object to the .find() method.

Aleksei KankovJan 25, 2023
Test Postgres with Jest Plugin Only
test-automation

Test Postgres with Jest Plugin Only

https://hackernoon.com

Dmytro HarazdovskiyJan 18, 2023
How to Solve Race Conditions in a Booking System
race-condition

How to Solve Race Conditions in a Booking System

https://hackernoon.com

Race conditions can occur in a booking database when multiple users try to access and update shared data concurrently. To solve race conditions, various concurrency control techniques can be used.

Georgii KliukovkinJan 9, 2023
What is an ORM – The Meaning of Object Relational Mapping Database Tools
Database

What is an ORM – The Meaning of Object Relational Mapping Database Tools

https://www.freecodecamp.org

Object Relational Mapping (ORM) is a technique used in creating a "bridge" between object-oriented programs and, in most cases, relational databases . Put another way, you can see the ORM as the layer that connects object oriented programming (OOP) to relational databases.

Ihechikara Vincent AbbaOct 21, 2022
Database Normalization – Normal Forms 1nf 2nf 3nf Table Examples
Database

Database Normalization – Normal Forms 1nf 2nf 3nf Table Examples

https://www.freecodecamp.org

In relational databases, especially large ones, you need to arrange entries so that other maintainers and administrators can read them and work on them. This is why database normalization is important. In simple words, database normalization entails organizing a database into several tables in order to reduce redundancy.

Kolade ChrisDec 21, 2022
How to Create World Leading Databases
slogging

How to Create World Leading Databases

https://hackernoon.com

Jaxon Repp is the SVP of HarperDB, a world-leading database and development platform that is leading the charge in terms of performance, flexibility, and ease of use. HarperDB is built to scale horizontally, so there's no limit to the throughput you can achieve with a cluster. It combines an extremely performant no-SQL data store with SQL semantics and an integrated API server powered by Fastify. Repp's role at HarperDB and career to date (which includes 8 startups), which is a whole different level of traction.

Jack BorehamOct 13, 2022
What the Heck is PRQL?
sql

What the Heck is PRQL?

https://hackernoon.com

PRQL stands for ‘Pipelined Relational Query Language’ (pronounced Prequel) and is a modern language for transforming data. PRQL is a simple, powerful, pipelined SQL replacement. It can be used with any database that uses SQL, since it compiles to SQL. The language also benefits from modern features, such syntax for dates, ranges and f-strings as well as functions, type checking and type checking. The resulting example is a basic example that reads from the employees' table and shows the id, name, and age, sorted by age and limited to 10.

Shawn GordonOct 12, 2022
Newsletter

Let's keep in touch

Benefit from a weekly updates, coding challenges and helpful resources around software development.

Your privacy is important to us. We promise not to send you spam!