Database recommendations?

[dontommy]

Hey
New to the forum.. hey

My work station have for years been different variants of linux.
However on the server side, I am running Windows - and only because of the MS SQL Server.
The best part of MS SQL Server, is for me, the SQL Agent Jobs. Where I easy can call a number of python scripts, and stored procedure in the correct order. And get a nice overview over the different agent jobs running, and see where they fail etc etc.

However I want to change my server to linux - and for that I need a database system, that have features and nice overview like the MS SQL Server and SQL Agent Jobs.
And have a nice GUI tool, to work in.

What can you guys recommend? MariaDB, mySQL, Postgre or another?
Let me hear your thoughts, thanks

(And no MS SQL Server for Linux, is not an option for me)

 

[arochester]

To some extent it depends on what you are using it for and how much data you are carrying.

http://www.yolinux.com/TUTORIALS/Li...sidered the most advanced. ... More items...

 

[f33dm3bits]

Why is MS-SQL Server for Linux not an option for you, if you have experience with MS-SQL why no use what you know? If you want a real database system like MS-SQL you could have a look at Oracle.

 

[KGIII]

I use MySQL and MariaDB, though I seldom need to interact with 'em. I've even got a small site that uses SQLite, which runs like a champ. When you say a nice GUI to work with, what exactly are you wanting to do with it? I use phpMyAdmin (for example), which can't really be referred to as a 'nice GUI' but it meets my simple needs.

 

[captain-sensible]

I use MySQL and MariaDB, though I seldom need to interact with 'em. I've even got a small site that uses SQLite, which runs like a champ. When you say a nice GUI to work with, what exactly are you wanting to do with it? I use phpMyAdmin (for example), which can't really be referred to as a 'nice GUI' but it meets my simple needs.

I also like SQLIte3 it has apparently capacity circa 281TB surely thats enough for most web s ; MySQl has user db password and user but doesn't add anything to whats using it. What would you say are thr downsides of Sqlite3 ?

 

[KGIII]

What would you say are thr downsides of Sqlite3 ?

Last I knew, it was limited to just 2 GB? Other than that, it was great. If that has been changed, I'd not be surprised to see more projects adopt it. It's fast, doesn't require installation, it's easily transferred, etc... It's a great system.

 

[captain-sensible]

on sqlite site they are now quoting > 200TB : https://sqlite.org/limits.html

 

[KGIII]

That's impressive. I'd expect to see some projects offering it as a solution/choice. I know you can configure WordPress to use SQlite with a plugin, and WP runs a giant chunk of the 'net.

 

[captain-sensible]

i've got WP on apache local host (for research ) with sqlite plugin ;this one:

=== SQLite Integration ===
Contributors: kjmtsh
Plugin Name: SQLite Integration
Plugin URI: http://dogwood.skr.jp/wordpress/sqlite-integration/
Tags: database, SQLite, PDO
Author: Kojima Toshiyasu
Author URI: http://dogwood.skr.jp/
Requires at least: 3.3
Tested up to: 4.1.1
Stable tag: 1.8.1
License: GPLv2
License URI: http://www.gnu.org/licenses/gpl-2.0.html

last time i looked it wasn't officially available . Also i found it doesn't work with e-commerce eg woocommerce. I use sqlite with all my web don't see the point of MySQl

 

[KGIII]

last time i looked it wasn't officially available

No, you need a plugin - as you have done. It's not native.

Also i found it doesn't work with e-commerce eg woocommerce.

That's going to be a showstopper for greater adoption. Those are essential plugins for some folks and are entire ecosystems.

But, maybe... We need to find a way to make it trendy, and that'll lead to greater adoption. Heck, it's even ACID compliant, I'm pretty sure. I'm pretty sure you can even host it on an external server. I'm not so sure if you can run it across clusters, but there's probably a way.

 

[dbdemon]

I'm not so sure if you can run it across clusters, but there's probably a way.

Yes, you can, with distributed sqlite a.k.a. dqlite:

Canonical Dqlite | Canonical Dqlite

Dqlite is a fast, embedded, persistent SQL database with Raft consensus that is perfect for fault-tolerant IoT and Edge devices.

dqlite.io

It's important to note SQLite's limitations and only use it for appropriate use-cases:

Appropriate Uses For SQLite

TL;DR: Don't use it if the data is separated from the application by a network, if there are many concurrent writers, or big data (terabyte area). In those situations, you should use a proper client-server database system.

 

[dbdemon]

Back to the original question about alternatives to MS SQL and SQL Agent Jobs:

The best part of MS SQL Server, is for me, the SQL Agent Jobs. Where I easy can call a number of python scripts, and stored procedure in the correct order. And get a nice overview over the different agent jobs running, and see where they fail etc etc.

However I want to change my server to linux - and for that I need a database system, that have features and nice overview like the MS SQL Server and SQL Agent Jobs.
And have a nice GUI tool, to work in.

What can you guys recommend? MariaDB, mySQL, Postgre or another?
Let me hear your thoughts, thanks

MariaDB has quite extensive documentation for people who are migrating from SQL Server:

Migrating to MariaDB from SQL Server

mariadb.com

I'm not familiar with SQL Agent Jobs, but it sounds a bit like what I'm trying to do in a little Github project here: https://github.com/DiamondLightSource/db-reports

It doesn't have a GUI or anything yet, but that is a long-term goal. My current plan is to integrate it with Ansible.