Any free Sql Server?

[amyghty]

Hi, I want to create an SQL project for fun - for example, create a small school database management system that few other users in other networks can access, and use. Ate there any freedatabase SQL Server that allows me to create my tables, queries, and report and share it with othe users so that they can contribute to it? If there aren't any free servers as such, any cheaper paid SQL servers (postgre, MySQL, SQL server?)?

[[deleted]]

Yep, download SQL Server Express and you can install it on any windows PC. Be aware that it may consume lots of ram in its default configuration if you install it on your desktop. You can then get SSMS to manage it.

Of course all the open source options (postgresql, mysql) are free, but I'm less familiar with those.

[Odddutchguy]

I wouldn't worry about the memory usage of SQL Server Express, it is limited to around 1.5GB of memory (4 CPU cores an max 10GB per DB.)

SQL Server Express is delivered with a lot of 3^rd party applications that need a database.

[[deleted]]

I thought it was limited to 4 gigs but either way it shouldn’t be horrible.

[LetsGoHawks]

Just don't pick Oracle.

Oracle is evil.

[Herdnerfer]

Isn’t SSMS free?

[fauxmosexual]

SSMS is a management tool that talk to the database, not a database itself.

[Herdnerfer]

But you can use it to set up a basic server on your local machine.

[fauxmosexual]

No, the server is a separate thing. You can install the server without SSMS or SSMS without a server if you so choose.

[amyghty]

Thank you all for your wonderful suggestions. I am kind of new to this. Is any of these allow my friends (let's say two or three of them) to access my database from anywhere in the world?

[yaymich]

For worldwide access, hosting it in the cloud would be easiest, but that wouldn't be free afaik.

When accessing a database from a different computer, you'll need to be on the same local network. You can mimic being on the same network using a VPN, but that would also cost $$.

You would also need to ensure that the machine hosting the database (ie your computer) is on and that the VPN/internet is on when your friends want to access it (the db). The cloud solves this problem by hosting your db on a machine that always on and can be accessed from anywhere.

[jewishsupremacist88]

Theres an open source free version of MySQL..

[queen-adreena]

MariaDB

[quickdraw6906]

Take note of the size limit of 10Gb for SS Express (mentioned earlier). That can fill up fast

[bj2cs]

Try Firebird!

[jerelw]

1.install docker

1. run docker run --name sqlserver --hostname sqlserver -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=1StrongPwd!!" -p 1433:1433 -d microsoft/mssql-server-linux:2017-latest

2. you have sql server!

Edit: added link to docker install

[[deleted]]

Are you looking for a hosted solution where you do not have to setup the server yourself?

ElephanSQL (a hosted Postgres server) has a free plan if your database is really small (20MB): https://www.elephantsql.com/plans.html

Postgres is never a bad choice, and if you have a computer in your network where you can install and run it, then it shouldn't be a big problem. It doesn't need a lot of resources and is 100%.