@tuckerteague 😆 since this is getting a lot of boosts, I WILL also say that on the current project I'm on, with a thoroughly microservices architecture, we're NOT using PostgreSQL (or any relational db -- datastores are primarily mongodb/DocumentDB), and in this case it feels appropriate.

#PostgreSQL #SQL #mongoDB #noSQL

Check out my article about #Geospatial capabilities in NoSQL🗺️ #MongoDB ! https://medium.com/@gisjohnecs/nosql-geospatial-with-mongodb-19fa7cc8e90 #GISChat #gis #nosql

@alexboly

Not sure if this helps, but my tricks for left joins are:

- Use #linqpad to generate queries for me.
- Swap them around
- Use aliases
- Use temporary tables
- Move things to #NoSql #database (a project can have relational and documents)
- Use views or stored procedures to split complex queries

Other than that: Good luck!

Reading #MongoDB documentation, and can't say that I find it enjoyable.🤔 At least, I miss the dark theme for it.🙂

#NoSQL #Database

Interesting solution 👉 Near-real-time analytics using Amazon Redshift streaming ingestion with Amazon Kinesis Data Streams and Amazon DynamoDB https://aws.amazon.com/blogs/big-data/near-real-time-analytics-using-amazon-redshift-streaming-ingestion-with-amazon-kinesis-data-streams-and-amazon-dynamodb/ #AWS #Analytics #Streaming #NoSQL #Database

Since YottaDB is so much more than M, we now have a Discord channel. Our thanks to David Wicksell & John Willis for help in moderating. Please join at https://discord.gg/bFHmDdzcqY

I hope to see you there.
#nosql #sql #discord

For dashboards, reports, and analytics, you can connect to #Octo using popular #Microsoft tools (PowerBI Desktop, PowerBI Report Builder, and Excel). Our blog post Connect Microsoft Analytics and Business Intelligence Tools to Octo (https://yottadb.com/connect-microsoft-analytics-and-business-intelligence-tools-to-octo/) guides you step-by-step. #nosql #sql

AWS Database Encryption SDK for Amazon DynamoDB now generally available 👉 To include client-side encryption in your DynamoDB workloads https://aws.amazon.com/about-aws/whats-new/2023/07/aws-database-encryption-sdk-dynamodb-available/ #AWS #Database #NoSQL #Security #SDK

Coming soon: PolyScale for MongoDB! We are pleased to announce that the next database to be supported by PolyScale.ai will be MongoDB. As with all currently supported databases, PolyScale will be wire-protocol compatible for a truly fully plug and play dev experience.

#mongodb #nosql

I have seen so many #startups with imaginary #scale problems. Everybody dreams about high loads and crazy and expensive overcomplicated hype-driven #architecture. I have a bingo like list : #aws , #serverless , #kubernetes , #kafka. #nosql.

Some times main bottleneck is team mindset. I have seen more cases where people and processes are not scaling - all other scalability is a coproduct of team topology and people #mindset.

Is your idea scalable?

Is your team scalable?

Tech rant.

Dear hotshot developers. Please stop suggesting nosql redis-esque solutions when the DB is slow. Have you looked at the execution plan? Have you considered indexing?

Please investigate this before suggesting alternative technologies. If I have to have this conversation again my head is going to explode.

#sql #programming #nosql #rant

@ellenor2000 @Elizafox Fair indeed.

The rest was more about the other options.

Which reminds me of this funny video about #NoSQL (particularly #MongoDB): https://www.youtube.com/watch?v=b2F-DItXtZs

🎧 Can't wait to listen to this episode of #DeveloperVoices with @krisajenkins speaking to Ben Stopford about the Evolution of Databases and the Future of Database Technology

https://www.youtube.com/watch?v=9JVPq_fbXVs

#RDBMS #DataEngineering #Databases #NoSQL#datadon

I got nerdsniped by @tef & @sushee to demonstrate how relatively easy it is to build a CRAQ (https://timilearning.com/posts/mit-6.824/lecture-9-craq/) system atop @couchdb — Showing that as much as CouchDB is a distributed database in itself, it is also a very nice toolkit to build other kinds of distributed databases with it :)

The demo is in Node.js with some private JS/HTTP API glue that is not relevant to the demo: https://gist.github.com/janl/d0ba3544631e054e59fbd5f4d3ee96f8

Let me know if you ahave any questions.

#CouchDB #DistSys #Databases #NoSQL #CRAQ

Does anyone have any #nosql suggestions, particularly a good iOS client app? I'm not particular about what the backend would have to be, as long as it doesn't require a whole lot of manual setup and maintenance. Just need a document data store that I can use for personal stuff and access from my phone. Evernote might have worked for this if it wasn't dying.

Introducing the AWS .NET Distributed Cache Provider for DynamoDB (Preview) 👉 To use DynamoDB as storage for ASP.NET Core’s distributed cache framework https://aws.amazon.com/blogs/developer/introducing-the-aws-net-distributed-cache-provider-for-dynamodb-preview/ #AWS #Database #NoSQL #Cache #DotNET

Handle conditional write errors in high concurrency scenarios with Amazon DynamoDB 👉 More info on how to use the new ReturnValuesOnConditionCheckFailure parameter https://aws.amazon.com/blogs/database/handle-conditional-write-errors-in-high-concurrency-scenarios-with-amazon-dynamodb/ #AWS #Database #NoSQL

Been deep in #NoSQL land at my day job lately. It’s a really interesting, alternate approach to thinking about databases, especially when modeling one-to-many or many-to-many relationships. I still prefer relational databases, but it’s good to expand my horizons a bit.

Announcing DynamoDB local version 2.0 👉 This latest version allows Java developers to use DynamoDB local with Spring Boot 3, Spring Framework 6, and Micronaut Framework 4 👏 https://aws.amazon.com/about-aws/whats-new/2023/07/dynamodb-local-version-2-0/ #AWS #Database #NoSQL #Java

Amazon DynamoDB now simplifies and lowers the cost of handling failed conditional writes 👉 Now error messages can include a copy of the item as it was during the write attempt at no additional cost https://aws.amazon.com/about-aws/whats-new/2023/06/amazon-dynamodb-cost-failed-conditional-writes/ #AWS #Database #NoSQL