Tag: Database
-
How to optimize SQL queries for faster data retrieval
Posted on October 30, 2023, Level beginner Resource Length medium
SQL (Structured Query Language), as you probably, know, helps you collect data from databases. It is specifically designed for that. In other words, it works with rows and columns, allowing you to manipulate data from databases using SQL queries. By Nate Rosidi.
Tags database software performance big-data analytics
-
Dynamic table partitioning in Postgres
Posted on October 29, 2023, Level intermediate Resource Length medium
We helped a customer recently who was storing 500 million chat messages in a single Postgres table. As the table was growing, their queries were slowing down. By Michel Pelletier.
Tags database mysql software performance
-
Bridging the gap between SQL and NoSQL in PostgreSQL with JSON
Posted on October 10, 2023, Level beginner Resource Length medium
PostgreSQL, a popular open-source relational database system can be used as a hybrid database to handle both structured and semi-structured data. PostgreSQL's support for JSON and JSONB object types allows for flexible data modelling and can solve many of the same problems that NoSQL databases are made to address. By Leslie S. Gyamfi.
Tags mysql big-data teams database nosql json
-
Running SQL server on Raspberry Pi using Docker
Posted on September 22, 2023, Level beginner Resource Length medium
The article walks through the process of installing Docker on Raspberry Pi and running Microsoft SQL Server using Docker1. It highlights the compatibility challenges between SQL Server and Raspberry Pi's ARM-compatible CPU and explains how Docker resolves this issue. By Manjiri Gaikwad.
Tags iot programming azure robotics app-development database
-
Artificial intelligence is a very real data center problem
Posted on September 16, 2023, Level beginner Resource Length medium
It would be stupid for us to not consider the consequences as tools like Open AI's ChatGPT or Google's Bard for example to proliferate and introduce machine intelligence to everyday people. That includes how our data centers are evolving amid the rapid growth in data that needs to be stored, processed, managed, and transferred. By Dr. Michael Lebby.
Tags ai data-science cio database big-data
-
Discussing PostgreSQL: What changes in version 16
Posted on September 15, 2023, Level beginner Resource Length long
The article discusses the new features and improvements in PostgreSQL 16, the latest version of the open source relational database. By Amit Kapila.
Tags mysql json cio database web-development
-
Working with Postgres JSON query
Posted on September 14, 2023, Level beginner Resource Length long
The article explains how to work with Postgres JSON Query, which is a feature that allows you to store and query JSON data in PostgreSQL. By Pratibha Sarin.
Tags mysql json microservices database web-development
-
Character sets and collations in MySQL
Posted on June 28, 2023, Level intermediate Resource Length medium
Understanding the differences between character sets and collations in MySQL. Character sets and collations are fundamentally important concepts to understand when dealing with string columns in MySQL. A slight misunderstanding of either can lead to poor performance or unexpected errors when inserting data. By planetscale.com.
Tags web-development app-development mysql database how-to
-
PayPal open sources key-value store JunoDB
Posted on June 27, 2023, Level beginner Resource Length long
PayPal last month released the source code for JunoDB, a distributed key-value store it developed internally and which today powers a variety of backend services at the payment site, including 350 billion transaction requests per day, the company says. By Alex Woodie.
Tags open-source performance web-development app-development database
-
LangChain has added Cypher Search
Posted on May 26, 2023, Level intermediate Resource Length medium
With the LangChain library, you can conveniently generate Cypher queries, enabling an efficient retrieval of information from Neo4j. By Tomaz Bratanic.
Tags apis app-development search database data-science
-
Autonomous database observability
Posted on May 21, 2023, Level beginner Resource Length medium
Autonomous Database (ADB) Observability blog series where we'll cover the basics of database observability and then introduce the most relevant Oracle tools and services that you can leverage to observe your Autonomous Databases. By German Viscuso.
Tags monitoring performance database analytics devops
-
Building and deploying MySQL Raft at Meta
Posted on May 19, 2023, Level intermediate Resource Length medium
At Meta, we run one of the largest deployments of MySQL in the world. The deployment powers the social graph along with many other services, like Messaging, Ads, and Feed. Over the last few years, we have implemented MySQL Raft, a Raft consensus engine that was integrated with MySQL to build a replicated state machine. By Anirban Rahut, Abhinav Sharma, Yichen Shen, Ahsanul Haque.
Tags mysql database cloud software-architecture app-development