What’s Next for SQL @ Scale? | TiDB Watch on demand and learn the new perspectives on multiple dimensions of scalability beyond data volume. Register now.

www.pingcap.com/htap-summit/...

Amazon Aurora Introduces Global Database Writer Endpoint for Distributed Applications Amazon Aurora has recently introduced a Global Database writer endpoint to streamline routing for applications in disaster-recovery scenarios. This highly available global endpoint removes the need fo...

www.infoq.com/news/2024/11...

The ultimate MySQL database platform — PlanetScale PlanetScale is the world’s most advanced, fully-managed MySQL database platform. Scale, performance, and reliability, powered by Vitess.

planetscale.com

Nicolas Hourcard, CFA on LinkedIn: QuestDB plugin for Grafana | Grafana Labs QuestDB is now an official data source for Grafana Labs 🔥 https://lnkd.in/e3YeyZVw Thank you, Logan Smith, for leading the process. Grafana is the…

www.linkedin.com/posts/nicola...

Another hidden little Rails gem I found out about this week. Swap out your database engine:

$ rails db:system:change —to=<new_db_type>

For situations where you wanted to change from SQLite to PostgreSQL to get ready for production, for example.

#dev #tips #ruby #ruby_on_rails

And how about 3 tips/tricks for your Oracle Database REST APIs?

https://www.thatjeffsmith.com/archive/2022/10/3-ords-rest-api-tips-tricks-for-oracle-developers/

The fact that DuckDB isn't a data warehouse...is the whole point of DuckDB!

Once you pull your head out of the snow or the bricks or wherever you spend most of your data engineering time, you will discover that there are data pipeline problems *everywhere* that benefit from data modeling and SQL!

Now, If using ENUM were our only option for representing what continent a country belonged to, we could all move on to debating the merits of NoSQL or whether Git was better than SVN, or why your favorite framework sucks. But there is a superior option to ENUM in most cases: the lookup/joined/reference table. (We'll call them reference tables.) It's pretty simple:

2011 tech blogs are delightful

GitHub - dcramer/mangodb: A database that operates at CLOUD SCALE A database that operates at CLOUD SCALE. Contribute to dcramer/mangodb development by creating an account on GitHub.

and use os.devnull to scale?
github.com/dcramer/mang...

Yes, database users are developers. But it must also be usable by end-users (scalability, resilience)

❄️ on the cloud
🦆 on laptop

☮️ A peaceful solution: your DBA thinks you are using Oracle, while your developers believe they are using MongoDB.
docs.oracle.com/en/database/...

User experience is how you should chose a database

A MongoDB API on top of SQL databases

Yes, it could be perfect if it was not Java with a garbage collection to tune

Dgraph: A distributed graph database designed for high-performance and scalability, enabling complex queries over large graph datasets. #Dgraph #GraphDatabase

Vertica: A columnar storage database optimized for high-performance analytics, ideal for data warehousing and business intelligence applications. #Vertica #Analytics

Firebird: An open-source SQL relational database known for its lightweight footprint and advanced features like stored procedures and triggers, great for embedded systems. #Firebird #OpenSource

Pivotal GemFire: An in-memory data grid that offers distributed SQL capabilities, allowing for low-latency data access and real-time analytics for large-scale applications. #GemFire #DistributedSQL

Greenplum: A massively parallel processing (MPP) database built on PostgreSQL, designed for data warehousing and analytics, capable of handling large-scale data. #Greenplum #DataWarehouse

CrateDB: A distributed SQL database optimized for machine data and analytics, providing scalability and support for real-time queries across large datasets. #CrateDB #DistributedSQL

MemSQL (now SingleStore): A distributed, in-memory SQL database that supports both transactional and analytical workloads, optimized for speed and real-time analytics. #SingleStore #DistributedSQL

ClustrixDB (now MariaDB X5): A distributed database designed for high availability and performance, particularly for online transaction processing, supporting SQL and NoSQL workloads. #ClustrixDB #DistributedSQL

NuoDB: A distributed SQL database designed for cloud environments, focusing on scale-out architecture while maintaining ACID compliance for transactional workloads. #NuoDB #CloudDatabase

TiDB: An open-source distributed SQL database that provides horizontal scalability and strong consistency, designed for online transaction processing (OLTP) and online analytical processing (OLAP) workloads. #TiDB #DistributedSQL

Google Spanner: A fully managed, horizontally scalable database service that offers global transactions with strong consistency and SQL support, ideal for large-scale applications. #GoogleSpanner #CloudDatabase

YugabyteDB: An open-source, distributed SQL database that offers strong consistency, horizontal scalability, and high availability, designed for cloud-native applications. #YugabyteDB #DistributedSQL

Microsoft Access: A desktop relational database management system that integrates well with other Microsoft products, suitable for small to medium-sized applications. #MicrosoftAccess #DesktopDatabase

Couchbase: A distributed NoSQL database that offers key-value storage with strong consistency and built-in caching, suitable for web and mobile applications. #Couchbase #NoSQL

InfluxDB: A time-series database optimized for high-write loads and real-time analytics, ideal for monitoring systems and IoT applications. #InfluxDB #TimeSeriesData