+- Sinisterly (https://sinister.ly)
+-- Forum: Computers (https://sinister.ly/Forum-Computers)
+--- Forum: Software & Programs (https://sinister.ly/Forum-Software-Programs)
+--- Thread: PostgreSQL vs MySQL vs MariaDB vs NoSQL (/Thread-PostgreSQL-vs-MySQL-vs-MariaDB-vs-NoSQL)
PostgreSQL vs MySQL vs MariaDB vs NoSQL - ProfessorChill - 10-16-2017
I have found PostgreSQL amazing for security and speed however it's a bit odd to learn if you are used to using MySQL. It also has a kickass library for C/C++
MySQL is only really good for quickly setting up databases, quick, dirty, but still fairly good on security. It does have a C/C++ library however integrating it into as object oriented program it pretty annoying.
MariaDB I find it the more user friendly version of all of these, it's pretty good for quick project but I would never distribute it as a full program as you can simply migrate it to MySQL pretty fast.
NoSQL This is a hard one since it is an AMAZING thing! However the issue lies within selection. For example, for quick temporary data I would use Redis, for longer lasting data I would still stick with PostgreSQL. There is a large selection of these which makes it hard to choose and requires a large amount of research. For speed though, definitely Redis.
What are your thoughts? I'll probably always use PostgreSQL for large projects and Redis for temporary data but I'm still interested in hearing your opinions.
RE: PostgreSQL vs MySQL vs MariaDB vs NoSQL - Pikami - 10-16-2017
I like PostgreSQL because:
- It supports lots of advanced data types, such as (multi-dimensional) arrays, user-defined types, etc.
- In my personal experience it's fast
I like MySQL because:
- It's very easy to use
- Supported by lot's of software
I like SQLite because:
- Everything is stored in one file so you do not need extra software
RE: PostgreSQL vs MySQL vs MariaDB vs NoSQL - mothered - 10-16-2017
I've been using MySQL for quite a while now, and will continue to do so.
Although some versions do not support certain functions and the attributes of Data Types may also vary, It's extremely simple to create, query, update, modify, delete etc data.
RE: PostgreSQL vs MySQL vs MariaDB vs NoSQL - zorrophreak - 10-16-2017
I've been using MySQL for so long that I've kinda learned to love and live with its flaws. Although using some type of NoSQL for a project a while back I have to say it really interests me as an alternative but I still prefer MySQL for basic use since its so common, easy to setup, and it just works...usually.
Haven't actually touched PostgreSQL any.
Oracle SQL is relatively similar to MySQL I believe and its what I used a bit before I got into more MySQL usage as its what my old school's servers used and its what I had to work with.
RE: PostgreSQL vs MySQL vs MariaDB vs NoSQL - Oni - 10-16-2017
I've used MySQL and MariaDB. MariaDB is pretty alright, if you wanted to try something new.
RE: PostgreSQL vs MySQL vs MariaDB vs NoSQL - Inori - 10-16-2017
I'm a big proponent of Postgres since it still scales incredibly well, isn't super memory intensive, and has several shortcuts (e.g. SERIAL type for ids).
On the contrary, I usually avoid MySQL because it's a huge memory hog.
SQLite is cool because it's easy to work with, portable, self-contained, and the CLI provides a nice tool suite. It's a bit of a challenge because several data types aren't supported due to its light weight, but it's great in a pinch.
I haven't used MariaDB, but for NoSQL Redis is my go-to.