Database recommendations?

dontommy

New Member
Credits
17
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)
 
Last edited:


f33dm3bits

Gold Member
Gold Supporter
Credits
7,721
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.
 
Last edited:

KGIII

Well-Known Member
Credits
3,559
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

Well-Known Member
Credits
7,669
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 ?
 

captain-sensible

Well-Known Member
Credits
7,669
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

Well-Known Member
Credits
3,559
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.
 


Staff online

Members online


Top