DEV Community

Free SQL hosting providers ?

Sharad Raj (He/Him) on January 25, 2020

Let's discuss ...... 🤔

We have MongoDB Atlas for MongoDB and it provides 512mb of storage.

Is there any such service provider for SQL ?

Collapse
 
phlash profile image
Phil Ashby

Depends on your particular challenge but perhaps even SQLite over a file store would work well (and be very portable)?

Collapse
 
sharadcodes profile image
Sharad Raj (He/Him)

It is portable but you can't access it over network.

Collapse
 
phlash profile image
Phil Ashby

True, and you did ask for a 'as a service'. I have seen (and SQLite supports with caveats) SQLite used over a file share, although that brings back horrific memories of Access databases on SMB shares, or worse, Visual Source Safe - shudder.

Collapse
 
hwolfe71 profile image
Herb Wolfe

What type of network? We use an application that accesses one on a server on a daily basis.

Thread Thread
 
sharadcodes profile image
Sharad Raj (He/Him) • Edited

Sqlite is for local storage like in embedded systems. You cannot access it remotely. You need either an API running on that server or some other interface to do database manipulation.

Where as client server based dbms like MySQL can be accessed via a domain, port, username, password. So you don't have db stored on the system where that app or software is running.

Example of such applications are based on the way you implement.

Like you can make a todo app with sqlite but in that case both the db and app will be on same server.
In another case you can use MySQL, MongoDB etc to store db elsewhere and app will be hosted somewhere else.

Collapse
 
ben profile image
Ben Halpern

Heroku's postgres plans start free but are super limited and only allow up to 10k rows. First thing that comes to mind.

Collapse
 
petecapecod profile image
Peter Cruckshank

That's what I was going to say. 👍😂

Collapse
 
andrewbrown profile image
Andrew Brown 🇨🇦

Oh, I never knew there was a row limitation. Still, free forever at 10K rows is a great deal

Collapse
 
sharadcodes profile image
Sharad Raj (He/Him) • Edited

It's good but you should have a credit card 🤔

Collapse
 
devanghingu profile image
Devang Hingu

why you worry about free sql provider?? i think you should start with aws, azure or google cloud free instance to create. where you can install any SQL packages and can use it anywhere without any limits(with your own criteria).
i think it will be good for you.

Collapse
 
endy_tj profile image
Endy Tjahjono

All three will be free for a year or two, and then you need to pay to continue.
If you only need one year, then you are good!

Collapse
 
devanghingu profile image
Devang Hingu

but we can go with another account. when one or two year will be done.

Collapse
 
devanghingu profile image
Devang Hingu

also keep in mind free SQL-provider will not keep your data safe. just see their terms and condition.

Collapse
 
krhoyt profile image
Kevin Hoyt

Not SQL, but IBM Cloudant (CouchDB) is free up to 1Gb.

Collapse
 
sharadcodes profile image
Sharad Raj (He/Him)

How to avail?

Collapse
 
krhoyt profile image
Kevin Hoyt

It is part of IBM Cloud (disclosure: IBM employee). More information at: ibm.com/cloud/cloudant

Collapse
 
khrome83 profile image
Zane Milakovic

Not SQL, but I am a huge fan of fauna DB. Super generous free teir, and Serverless to boot. Native GraphQL and ABAC controls built in. Also has time travel. It’s super powered! You can even do relations!

Collapse
 
sharadcodes profile image
Sharad Raj (He/Him)

Thanks for the new info 😃

Collapse
 
andrewbrown profile image
Andrew Brown 🇨🇦

For AWS you can get a t3.db.micro (1 GB) on free-tier for 1 year which is very good.
I think Ben highlighted the best deal on Heroku.

Collapse
 
mattnot profile image
Matteo Notaro

There's elephantsql.com/ but has huge limitations

Collapse
 
sharadcodes profile image
Sharad Raj (He/Him)

I'll have a look

Collapse
 
osde8info profile image
Clive Da

Sure run 2 Oracle Cloud instances for free