Tag: Mysql
-
Postgres: Better message queue than Kafka?
Posted on October 13, 2022, Level intermediate Resource Length long
Today author is going to talk about why they made the unconventional decision to build thier logging system on top of Postgres, what worked well, what didn't work well, and how they did it. By Pete Hunt.
Tags apache mysql app-development database messaging
-
Seven ways to reduce MySQL costs in the cloud
Posted on August 30, 2022, Level beginner Resource Length medium
With the economy slowing down and inflation raging in many parts of the world, your organization will love you if you find ways to reduce the costs of running their MySQL databases. This is especially true if you run MySQL in the cloud, as it often allows you to see the immediate effect of those savings, which is what this article will focus on. By Peter Zaitsev.
Tags mysql cio devops cloud database
-
Data Manipulation with functional programming and queries in Ballerina
Posted on August 18, 2022, Level intermediate Resource Length medium
As an adept at Functional Programming (FP), I feel at ease with expressing my data manipulation logic by chaining high order functions like map, filter, and sort operating on arrays and maps. Ballerina, being designed as a Data-Oriented programming language, supports this FP style of coding. By Yehonathan Sharvit.
Tags app-development programming database functional-programming mysql
-
Scaling up and load balancing your PostgreSQL Cluster using Pgpool-II
Posted on July 12, 2022, Level intermediate Resource Length medium
PostgreSQL's speed, robustness and security makes it suitable for 99% of the new-age applications. Today, let's deep dive into how you can enable scalability and load balancing of your PostgreSQL cluster using Pgpool-II. By Azman Agung Nugraha.
Tags database performance software-architecture mysql
-
Working with a JSONB array of objects in PostgreSQL
Posted on July 7, 2022, Level intermediate Resource Length medium
Get, add and remove JSON objects from an array. By Rob Tomlin.
Tags json database mysql app-development
-
Migrating to utf8mb4: MySQL things to consider
Posted on May 1, 2022, Level intermediate Resource Length medium
The utf8mb4 character set is the new default as of MySQL 8.0, and this change neither affects existing data nor forces any upgrades. By Sveta Smirnova.
Tags mysql web-development app-development database
-
MySQL 8: Password verification policy
Posted on April 28, 2022, Level intermediate Resource Length medium
The artcicle discusses the password verification-required policy introduced in MySQL 8.0.13. With this feature, it is possible to require that attempts to change an account password be verified by specifying the existing current password to be replaced. By Brian Sumpter.
Tags mysql database cio infosec devops
-
Tiered datastore solution for high data growth MySQL using Distributed SQL Databases (DSQL)
Posted on December 10, 2021, Level intermediate Resource Length medium
Usually, entities like order, order items etc tend to grow substantially year on year as we scale more and serve large customers. Generally, MySQL is the widely used datastore due to its durable & ACID guarantees. While MySQL is a brilliant tech stack, it comes with the overhead of data maintenance. By Manohar K.
Tags cloud database mysql cio distributed
-
How does an SQL injection attack work? Examples & types
Posted on December 6, 2021, Level intermediate Resource Length medium
A SQL injection (SQLi) attack is one of the most threatening issues for data integrity and confidentiality today, allowing attackers to access secure data where they are not authorized. In this article, we discuss SQLi and how these attacks work, with types and examples. By Al Mahmud Al Mamun.
Tags servers mysql database miscellaneous cloud cio distributed
-
Transitioning from MySQL to MongoDB
Posted on November 7, 2021, Level beginner Resource Length long
This article will not discuss the different types of database systems, like RDBMS and so on. We will, however, focus on two concepts: SQL Databases and NoSQL databases. By @peteradeojo.
Tags nosql database software mysql devops
-
Hosting SQLite databases on Github Pages
Posted on October 25, 2021, Level beginner Resource Length medium
I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. But if you want to use a database, you either need to write a backend (which you then need to host and maintain forever) or download the whole dataset into the browser (which is not so great when the dataset is more than 10MB). By phiresky's blog.
Tags database app-development mysql javascript
-
Postgres full-text search: Search engine in a database
Posted on October 9, 2021, Level intermediate Resource Length medium
So when we say PostgreSQL is the "batteries included database," this is just one reason why. With Postgres, you don't need to immediately look farther than your own database management system for a full-text search solution. If you haven't yet given Postgres' built-in full-text search a try, read on for a simple intro. By Kat Batuigas.
Tags database search microservices nosql software-architecture cloud mysql