InfoQ Homepage Relational Databases Content on InfoQ
-
/articles/typescript-mysql/en/smallimage/typescript-mysql-s-1556297412283.jpeg)
Using TypeScript with the MySQL Database
TypeScript has emerged as a powerful environment for authoring web applications, providing significant improvements over standard JavaScript while remaining consistent with the language. In this article we'll explore in depth the details necessary to use TypeScript with Node.js, MySQL, and TypeORM to create a powerful solution for managing database access with server-side TypeScript.
-
/articles/relational-nosql-fauna/en/smallimage/relational-nosql-fauna-s-1543858323385.jpeg)
Back to the Future with Relational NoSQL
This article outlines some of the consistency issues NoSQL databases have with distributed transactions, showing how FaunaDB has solved the problems using the Calvin protocol and a virtual clock.
-
/articles/DevOps-Databases/en/smallimage/DevOps-Databases-s-1541670287515.jpeg)
How to Source Control Your Databases for DevOps
A robust DevOps environment requires having continuous integration for every component of the system. But far too often, the database is omitted from the equation. In this article, we discuss the unique aspects of databases, both relational and NoSQL, in a successful continuous integration environment.
-
/articles/challenges-realtime-chat-service-pusher/en/smallimage/challenges-realtime-chat-service-pusher-s-1541510495755.jpeg)
Challenges of Building a Reliable Realtime Chat Service
Realtime chat has become a common feature of modern applications. These days not only communicators and social networks allow users to talk with each other over the Internet—chat is crucial in healthcare, e-commerce, gaming and many other industries.
-
/articles/monitoring-SRE-golden-signals/en/smallimage/logo-8-1524683952703.jpeg)
Monitoring SRE's Golden Signals
Golden signals are increasingly popular these days due to the rise of SRE. This article outlines what golden signals are, and how to monitor and use them in the context of various common services.
-
/articles/faunadb-serverless/en/smallimage/LOGO-FAUNA.jpg)
Introducing FaunaDB Serverless Cloud
FaunaDB Serverless Cloud is the managed version of FaunaDB, a serverless, object-relational, globally replicated, strongly consistent, temporal database, that can be deployed on multiple clouds, such as AWS, GCP, and Azure, or on premises.
-
/articles/sql-server-containers/en/smallimage/stanton-logo.jpg)
Introduction to SQL Server Containers
Containers are just around the corner for the Windows community, and this article takes a closer look at using SQL Server containers. The author discusses the value, use cases, and means for taking advantage of SQL Server containers today.
-
/articles/unified-data-modeling-for-relational-and-nosql-databases/en/smallimage/logo1.jpg)
Unified Data Modeling for Relational and NoSQL Databases
Current enterprise data architectures include NoSQL databases co-existing with relational databases. However, NoSQL data management currently lacks mature methods and tools to manage NoSQL data. In this article, author discusses a solution for managing both NoSQL and relational databases using Unified Data Modeling techniques.
-
/articles/Diagnosing-Common-Java-Database-Performance-Hotspots/en/smallimage/logo.jpg)
Diagnosing Common Database Performance Hotspots in our Java Code
Java performance issues are often attributable to bad database access patterns. In this article a top performance field engineer demonstrates his patterns for diagnosing database related issues.
-
/articles/real-time-data-processing-in-aws-cloud/en/smallimage/logo-aws.jpg)
Real-time Data Processing in AWS Cloud
In this article, author Oleksii Tymchenko discusses a bio-informatic software as a service (SaaS) product called Chorus, which was built as a public data warehousing and analytical platform for mass spectrometry data. Other features of the product include real-time visualization of raw mass-spec data.
-
/articles/SQL-Server-ColumnStore/en/smallimage/big-data-logo.jpg)
Big Data Solutions with MS SQL ColumnStore Index
Columnar data storage can offer significant performance improvements over the way database tables are traditionally stored, but they aren’t always faster. Aleksandr Shavlyuga explores the power, and limitations of SQL Server’s ColumnStore Indexes.
-
/articles/SSDT-Intro/en/smallimage/logo2.jpg)
SQL Server Source Control and Deployment with Visual Studio
The holy grail of database development is the ability to treat database objects (tables, views, stored procedures, etc.) as if they were just like any other form of source code. While SQL Server Data Tools doesn’t quite that level, it gets very close.