banner
databases.bsky.social
@databases.bsky.social
Pinned
☮️ A peaceful solution: your DBA thinks you are using Oracle, while your developers believe they are using MongoDB.
docs.oracle.com/en/database/...
Oracle Database API for MongoDB - Home
Home base for the Oracle Database API for MongoDB. Documentation, tutorials, videos, blogs,...
docs.oracle.com
Reposted
Another hidden little Rails gem I found out about this week. Swap out your database engine:

$ rails db:system:change —to=

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

#dev #tips #ruby #ruby_on_rails
September 13, 2024 at 11:48 AM
Reposted
Reposted
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!
November 4, 2024 at 5:01 PM
Reposted
2011 tech blogs are delightful
January 24, 2024 at 12:38 AM
❄️ on the cloud
🦆 on laptop
November 8, 2024 at 9:38 AM
☮️ A peaceful solution: your DBA thinks you are using Oracle, while your developers believe they are using MongoDB.
docs.oracle.com/en/database/...
Oracle Database API for MongoDB - Home
Home base for the Oracle Database API for MongoDB. Documentation, tutorials, videos, blogs,...
docs.oracle.com
November 8, 2024 at 9:33 AM
User experience is how you should chose a database
Practically every software system needs to store data at some point. Over my career, I've worked with databases like #SQLServer, #SQLite, Postgresql, and Oracle, as well as #NoSQL products like MongoDB, #CosmosDB, and RavenDB. You might think the best database is the fastest one, but... (cont'd)
November 8, 2024 at 9:30 AM
A MongoDB API on top of SQL databases
FerretDB: A MongoDB alternative using PostgreSQL as backend. Its query API mirrors MongoDB's, making it a seamless transition for PG users looking for a schemaless/document-oriented #NoSQL #OSS #DB
GitHub - FerretDB/FerretDB: A truly Open Source MongoDB alternative
A truly Open Source MongoDB alternative. Contribute to FerretDB/FerretDB development by creating an account on GitHub.
buff.ly
November 8, 2024 at 9:28 AM
Dgraph: A distributed graph database designed for high-performance and scalability, enabling complex queries over large graph datasets. #Dgraph #GraphDatabase
November 1, 2024 at 7:06 PM
Vertica: A columnar storage database optimized for high-performance analytics, ideal for data warehousing and business intelligence applications. #Vertica #Analytics
November 1, 2024 at 7:05 PM
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
November 1, 2024 at 7:05 PM
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
November 1, 2024 at 7:05 PM
Greenplum: A massively parallel processing (MPP) database built on PostgreSQL, designed for data warehousing and analytics, capable of handling large-scale data. #Greenplum #DataWarehouse
November 1, 2024 at 7:05 PM
CrateDB: A distributed SQL database optimized for machine data and analytics, providing scalability and support for real-time queries across large datasets. #CrateDB #DistributedSQL
November 1, 2024 at 7:04 PM
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
November 1, 2024 at 7:04 PM
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
November 1, 2024 at 7:04 PM
NuoDB: A distributed SQL database designed for cloud environments, focusing on scale-out architecture while maintaining ACID compliance for transactional workloads. #NuoDB #CloudDatabase
November 1, 2024 at 7:04 PM
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
November 1, 2024 at 7:04 PM
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
November 1, 2024 at 7:03 PM
YugabyteDB: An open-source, distributed SQL database that offers strong consistency, horizontal scalability, and high availability, designed for cloud-native applications. #YugabyteDB #DistributedSQL
November 1, 2024 at 7:03 PM
Microsoft Access: A desktop relational database management system that integrates well with other Microsoft products, suitable for small to medium-sized applications. #MicrosoftAccess #DesktopDatabase
November 1, 2024 at 7:03 PM