I have started to dabble with SQL, now I’m considering installing one of the database Apps to create a SQL server. However I have no idea which of the 7 apps would be suitable for me. The information within the installers is very limited. Looking for advise from the community
The SQL server will get very limited traffic, mostly just me
I’m planning to create databases which Excel can query. Also it would be nice if the server could query data from online sources periodically.
System: Intel(R) Xeon(R) CPU D-1521 @ 2.40GHz with 128GB mem running latest Scale
If i remember correctly, you can connect natively from excel to a MSSQL db, but consider
only the express edition Is free (still overkill for your use case, unless your DB stay below the 10gb limitation)
Is really powerful, but the same can be a bit harder to start with
don’t know if Is available in the app catalogue
Mariadb has an addon, postgres need ODBC (or Power query).
I would consider those 3, but only because im more or less familiare with
Mariadb Is the simpler of the 3, but i like way more postgres and mssql
I don’t think the DB should achieve that. Or maybe i didn’t understand what you mean
Thanks for the input. Mssql express is not one of the 7 standard truenas db apps. Before I start looking at installing non standard instances I would like to receive advice on these apps:
CloudBeaver
InfluxDB
Mariadb
Memcached
MongoDB
Postgres
Redis
I don’t think the DB should achieve that. Or maybe i didn’t understand what you mean
I”m still new with SQL databases. What I mean is that I would like the instance in which the SQL server runs to retrieve data from an online source and have the data added to a table without interaction from my side
Afaik Is for time series data, very adviced for this work, but i don’t have direct experience on It (just seen It on Scrutiny)… and don’t seems your use case
Is not a database
Is a nosql db
Is not a database
Those 2 for me, if you exclude MSSQL, are the best (only viable) choices.
So i confirm this Is totally out of scope of a database. There are for sure caveaut but not something i would raccomend
Just to clarify, you want a database server. “SQL Server” is a name of one, particular database server system, just like Oracle, MySQL, Postgre etc. So, if you say “I want SQL Server”, people may think that you want this particular one. Say “database server” instead.
@jaleksic Thank you for the clarification . You are right, I want to add an database server to my TrueNAS box. I’ve been dabbling with MS-SQL at work and didn’t know that MySQL used different ‘code’ (is this the right term for the database query commands?). I can’t edit my OP, or I would change my original request.
I am looking for advise which database server would be best for me.
In the future I might also sent IoT sensor data to the server. Should I consider several server instances for different tables or can I group al the tables in one database?
Another purpose would be a kind of a document management system (DMS) for receipts and manuals eg. Or am I aiming to high?
Currently I’m still on core, but planning to move to scale soon. In BSD I understand that jails hardly take up more system resources, is this similar with Scale (linux/docker)?
Better said, “different SQL dialect”. All RDBMS are more or less compliant with an SQL standard. Actually, you can even write your queries in an RDBMS-agnostic manner (but usually nobody does).
If you want a free (as in beer) solution, you should go with postgres IMO. It almost always has features like a solution from big guys (Oracle, MS), just a little worse… or much worse. However, I’m not really sure that you definitely need a relational database for your project.
Yeah, you can have them on the same database. And usually RDBMS can have more than one database per instance.
TBH, this question (and some others) leaves me with the impression that you are very new to the topic of databases. I think you should watch some tutorials on any RDBMS. Just an introduction for 30-60 min would be enough.
Also, the database topic is not directly related to truenas. It can be better to ask in developers/DBAs communities.
You are right, I’m quite a noob. The database discussion is a bit off topic, but the main question remains, which of the standard Scale apps (InfluxDB, Mariadb, MongoDB, Postgres) would be most suitable to my current plans?
dBeaver-ce is also a client but is free is someone is looking for a client. I use it quite often and it does a good job, will connect to almost any major database and is easy to setup. The other Beaver clients are not free.
Excel can easily connect to both mysql and mariadb. As a plus both are used for web services. Either of these are easy to install and to learn with and both are very similar in syntax to sql.
IMO, you shouldn’t tie yourself to the availability of the truenas apps. You should choose the storage for your app(?) and then deploy it one way or another. If there is no app, you can always just spin up a VM and install (almost) any required database solution.
Also, your requirements are kinda vague… Is your entire app supposed to be an excel document that can connect to the database? And then you want to populate your database (or document?) with online data? AFAIK there are two options if this is the case:
Get the data via programming excel macros. This method is far from perfect. At least in my opinion.
Get the data via programming RDBMS functions. This method is even worse.
For any serious data crawling you need to use a “real” programming language. At least bash/powershell.
. You are right, I want to add an database server to my TrueNAS box. I’ve been dabbling with MS-SQL at work and didn’t know that MySQL used different ‘code’ (is this the right term for the database query commands?). I can’t edit my OP, or I would change my original request.
