These two are all you will ever need
 Shopping Cart Returner Shirt $21.68 |
 DMT Has Friends For Me Shirt $21.68 |
Shopping Cart Returner Shirt $21.68 |
Postgres & SQLite
These two are all you will ever need
Shopping Cart Returner Shirt $21.68 |
DMT Has Friends For Me Shirt $21.68 |
Shopping Cart Returner Shirt $21.68 |
doesn't postgres use a shitton of memory?
why not sqlite and mariadb?
>doesn't postgres use a shitton of memory
Not that much memory, no. You can make it 40 times more performant with the Citus extension and even more if you use the ZFS file system though. With those, it can scale horizontally accross different machines with no compromise to the data integrity and will keep applying the foreign key relationships accross different machines.
MariaDB works poorly at scale and is shit at OLAP (online analytical processing). Postgres offers faster reads and writes and more features. It's not just a SQL database, it's also a NoSQL and JSON document database like MongoDB and a geospacial database with PostGIS. PostgreSQL has a lot of advanced features such as materialized views and partial indexes which enhance performance. MariaDB doesn't.
Good to know, been trying to learn to use different kinds RDBMS and have mostly looked at mysql variants (i.e. mariadb and alike). Will have to look into the NoSQL and Document database aspects of postgres.
Yes, instead of learning many different things i suggest you focus on Postgres. It took over OracleDB which used to be the get go solution for enterprises. It's getting better and better.
And now there's this new Postgres extension which solves the oldest of all SQL issues while boosting the performance of your database (horizontal scaling) at the same time. You can now scale your DB horizontally accross different machines without compromising the global integrity of your model and relationships.
>And now there's this new Postgres extension which solves the oldest of all SQL issues while boosting the performance of your database (horizontal scaling) at the same time. You can now scale your DB horizontally accross different machines without compromising the global integrity of your model and relationships.
wWhich one?
Citus
>"Citus Data provides the horizontal scalability of a NoSQL database with the transactional consistency and functionality of a relational database. At a high level, Citus distributes the data across a cluster of commodity servers. Incoming SQL queries are then parallel processed across these servers. It uses an architecture similar to Hadoop: one master node uses metadata about the shards and parcels out fragments of incoming queries to worker nodes that actually run the query pieces in in parallel. Distributing the query across the cluster harnesses the processing power of all of the involved nodes and all the individual cores on each node."
In picrel, comparison of a query on a 500 million row table with and without Citus
>Without
took 53 minutes
>With
took 10 seconds
>[citus] parcels out fragments of incoming queries to worker nodes that actually run the query pieces in in parallel
is this done with any sort of proportion according to the RAM/CPU/DISK available on each server node? so 1 big server and 2 little ones for example shouldn't be equally sharded
>Citus extension and even more if you use the ZFS file system
how do you mean? I imagine you mean to use ZFS as a way to dedup or branch or backup tables easily? something like neon is trying to do.
I was also under the impression MariaDB was way better for heavy reads or fullscan reads as you can set the block size to match your block storage. MariaDB is dogshit for CASCADE DELETES, I can tell you that much. I also love how planetscale was only able to achieve planet scale by removing foreign keys. What a crock. But I'm starting to wonder if I should just cronjob with dolt (command line versionable mysql) once a night to achieve the same sort of thing.
>It's not just a SQL database, it's also a NoSQL and JSON document database like MongoDB and a geospacial database with PostGIS. PostgreSQL has a lot of advanced features such as materialized views and partial indexes which enhance performance. MariaDB doesn't.
very interesting info. thank u for sharing ur knowledge
Only post on IQfy worth a shit in the last two weeks
Postgres is:
>A SQL Database
>A NoSQL Database
>A Document based database (like MongoDB)
>A Search database (like ElasticSearch)
>A Distributed Transactional and Analytical Database with Citus (like BigQuery)
How can anything else compare?
fauna is all of those things with RBAC & lambda functions within transactions as well. put graphCDN in front and I don't see anything better for typical CRUD of any scale.
Jack of all trades master at none.
Postgres is the Python of dbms.
>Jack of all trades master at none.
That's not what Postgres is. It's a superior solution and a better SQL database than all it's competitors with a built-in full-text search. Take MongoDB as an example. MongoDB limits its BSON format to a maximum of 64 bits for representing an integer or floating point number. Postgres's JSONB format isn't limited. Postgres provides data constraint and validation functions, which help to ensure JSON documents are more meaningful. Call it the C++, Rust, C# or Java equivalent. Python is not similar in any shape or form to PG.
With Citus it works as a distributed database and gets rid of the horizontal scaling issues that the relational model of SQL enforces. It also becomes perfect for big data analytics. You can now analyse petabytes of data from a postgresDB.
There's a reason why enterprise are dropping Oracledb for Postgres.
It's a jack of all trades and master at one of them (being an RDBMS)
Master of many actually. It does Jsonb better than MongoDB and can scale as good as BigQuery (with Citus).
why
Because there's no server SQL database that can claim to be as good as Postgres and there is no embedded database that can claim to be as versatile and good as SQLite.
frick you I like it
I've started using sqlite a lot lately for a couple different projects and I'm not sure anyone would be able to convince me that it isn't one of the most useful programs written ever.
Yeah it's great for small projects
It is one of the most useful programs written ever. But SQLite was mainly meant to be an embedded DB. If you ever create a project where you have chances to reach the Terabyte, you should preferably switch to a more powerful DB on a server (eg. Postgres)
I'll keep that in mind thanks
size isn't the problem, other RDMS features are like:
- access control
- migrations (alter table is fricked in sqlite)
- sophisticated indices and constriants
- inserts/updates on views
- many concurrent writers
- sharding
How do I convince my boomer boss that he shouldn't use stored procedures for literally everything?
Oh shit.... Your boss is moronic anon...
That actually sounds good. See if you can get all your permissions managed on postgres as well.
Stored procs are evil. They offer no real advantages and the fact that SQLite basically makes it impossible to do stored procs is one of its biggest advantages.
master/worker
I've been enjoying wienerroach db. It has very easy maintenance, scaling and high availability. Also generous fully managed free tier for hobby projects.
Not as many features as postgres but much less work to upkeep.
fully agree. both excellent tools for their respective purposes. postgres is super comfy.
Add redis to that and you will never need anything else.
l
I’m a cassandra man, myself
More like Postgres DataBased amirite
It's free real estate.
MySQL (because it's mine)
Anything but Oracle.
Frick Oracle.