Home/Databases
Topic

Databases

364 articles on Databases.

13,309 articles
Databases — Creating Secure Password Flows With NodeJS And MySQL — Smashing Magazine

Creating Secure Password Flows With NodeJS And MySQL — Smashing Magazine

Reset password functionality is table stakes for any user-friendly application. It can also be a security nightmare. Using NodeJS and MySQL. Today, Darshan Somashekar demonstrates how to successfully create a secure reset password flow so you can avoid these pitfalls. Darshan will be using NodeJS and MySQL as the base components. If you’re writing using a different language, framework, or database

DSDarshan SomashekarDarshan Somashekar·March 11, 2020Databases
Databases — Important Health Checks for your MySQL Master-Slave Servers - High Scalability -

Important Health Checks for your MySQL Master-Slave Servers - High Scalability -

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. In this blog post, we explain some basic health checks you can do on your MySQL master and slave nodes to ensure your setup is healthy. The monitoring program or script must alert the high availabili

KAKristi Anderson·February 17, 2020Databases
Databases — Using CSCS Scripting Language For Cross-Platform Development — Smashing Magazine

Using CSCS Scripting Language For Cross-Platform Development — Smashing Magazine

As opposed to JavaScript and Python, variables and functions in CSCS are case-insensitive. The primary goal of CSCS is to let the developer write as little code as possible. In this article, Vassili Kaplan explains how you can use a scripting language to develop cross-platform mobile applications. You’ll find examples in both iOS and Android that include placing widgets on the screen, SQLite, Web

VKVassili KaplanVassili Kaplan·January 29, 2020Databases
Databases — Follower Clusters – 3 Major Use Cases for Syncing SQL & NoSQL Deployments - High Scalability -

Follower Clusters – 3 Major Use Cases for Syncing SQL & NoSQL Deployments - High Scalability -

Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. Unlike cloning or replication, this allows you to maintain an active, point-in-time copy of your production data. This extra cluster, known as a follower cluster, can be leveraged for multiple use cases, including for analyzing, optimizing and testing your application perf

KAKristi Anderson·January 22, 2020Databases
Databases — PostgreSQL Connection Pooling: Part 2 – PgBouncer - High Scalability -

PostgreSQL Connection Pooling: Part 2 – PgBouncer - High Scalability -

When it comes to connection pooling in the PostgreSQL world, PgBouncer is probably the most popular option. It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. A client connects to PgBouncer with the exact same syntax it would use when connecting directly to PostgreSQL – PgBouncer i

KAKristi Anderson·January 8, 2020Databases
Databases — Evolutionary Database Design

Evolutionary Database Design

Over the last decade we've developed and refined a number of techniques that allow a database design to evolve as an application develops. This is a very important capability for agile methodologies. The techniques rely on applying continuous integration and automated refactoring to database development, together with a close collaboration between DBAs and application developers. The techniques wo

PSPramod Sadalage and Martin Fowler·Databases
Databases — Domain Logic and SQL

Domain Logic and SQL

Over the last couple of decades we've seen a growing gap between database-oriented software developers and in-memory application software developers. This leads to many disputes about how to use database features such as SQL and stored procedures. In this article I look at the question of whether to place business logic in SQL queries or in-memory code, considering primarily performance and mainta

MFMartin Fowler·Databases