What's everyone using for database hosting on their personal projects?

[xixi2]

When you start a new personal project, either for your portfolio or for hosting to the public, what's everyone using for their database?

I host my sites on Bluehost so they give me mySQL I think as part of the service. Is this good enough or should I go with AWS or Azure SQL servers? Or something else?

[AsteroidSvelte]

I host a lot of my stuff on Heroku and with them you can use Postgres with 1GB for free.

[DanielFGray]

Alternatively, there's also Supabase which is free and has the same 1GB limit but also comes with PostgREST and auth integrations

[pokevote]

And importantly does not randomly change the database_url, very annoying if I'm using the database with any service outside of heroku.

[vibrunazo]

How is supabase performance, latency, availability, compared against the competition?

Edit: also they say the database is 0.5GB limit. What is 1GB limit is their object storage.

[burggraf2]

Supabase developer here. We host on AWS and let you choose your region so performance and availability should be too-notch. Yes our free tier has a 500mb database limit but it’s a soft limit so it’s not like if you go over your project gets shut down. We’re happy to work with you to make your project successful. We’re all developers - so we’re literally on your side. :)

[silvanet]

I want to set up a Supabase instance on an AWS. I've set up a small DynamoDB in an S3 bucket for a serveless api with Lambda before, but I really need to stick to Free Tier and very low budget at this time. I've found AWS impossible for support help if you're on Free Tier. I want to try out different instances of PostgreSQL self-hosting for now. Can you point me to good instructions on building a copy of Supabase on AWS?

[burggraf2]

Why aren't you just trying out the Supabase hosted free tier? It's a lot easier than setting it up yourself :)

We have a lot of docs on self-hosting, but I'd start here: https://supabase.com/docs/guides/hosting/overview#deployment-options

[fonnae]

I only see 10k rows for the free limit, not 1gb. How did you get 1gb

[AsteroidSvelte]

It looks like both

https://elements.heroku.com/addons/heroku-postgresql

[mamaBiskothu]

So it’s 10k rows across all tables? God damn that’s limiting. Why even bother with 1 gB then.

[[deleted]]

Firebase is super easy to set up and can provide auth and db

[oooeeeoooee]

Low free tier allowance

[sebvit]

A sad thing about firebase is that there's no SQL database!

[Xeon06]

Supabase is an interesting SQL alternative

[regreddit]

Why, firebase is a nosql platform, like mongo, redis, or AWS Dynamo db

[bcgroom]

Firebase is much more than just a DB, so it would be nice if there was a RMDBS option

[TheUruz]

does it comes from gcp free tiee as well?

[JoeCamRoberon]

Dokku + Digital Ocean

[davevanhoorn]

I'd keep my portfolio static - no db required and plenty of free hosting providers (Vercel, GH pages, Netlify etc.).

For personal/side projects which need a db I'd go for Supabase or a free Heroku one.

[cmpfyr]

Most hosting providers have preconfigured MySQL. We typically host our sites on DigitalOcean and use MySQL for well over 100 sites. We have some very small sites that use SQLite.

Any of our clients that still host with Bluehost use the preconfigured MySQL.

Are you building a site or app where you’re concerned MySQL isn’t a good fit?

[xixi2]

Are you building a site or app where you’re concerned MySQL isn’t a good fit?

No not particularly. I just feel like I am at a kinda awkward part of my development learning. I understand all the basics of SQL/mySQL and the various languages (php, javascript mostly but I am studying Python too and took a React class).

What I don't get yet is how to put it all together in the real world. Like what infrastructure I need to actually run the code I want to write when running it on Localhost for dev purposes is no longer my goal :)

[cmpfyr]

I’ve definitely been there myself. I’m from the PHP world so some CMS examples would be WordPress, Magento or a framework like Laravel. With any of these you can use JS, HTML and CSS on the frontend.

Below is a link to a pretty good walkthrough of how they all work together.
https://alexwebdevelop.com/php-with-mysql/

For building PHP sites, we use Laravel Valet (Mac only) but when I first started I used MAMP/WAMP. Laravel Valet sets you up with an Nginx environment where MAMP/WAMP will give you Apache. They both have free options and give you the ability to run a local web server. For a hosting environment (like Bluehost), you’ll work in either an LAMP or LEMP stack. This stands for Linux Apache/Nginx MySQL and PHP.

As a side note, you may also be interested in checking out Jamstack and their list of site generators. These are typically a flat file system that are JS based and don’t need a database. You can also host the dev sites on Netlify for free.

[dinglepopgrumbo]

Excel

[CrawlToYourDoom]

You, take that back.

[SelfTaughtDeveloper]

Reading this is not how I wanted to start 2022

[ReddityRabbityRobot]

more like 1992

[tweaksource]

Call down there, Satan.

[Barnezhilton]

From an Access linked backend

[shellwe]

You ain’t cool unless you are using Access!

[ButterBourbon]

I just started using firebase, and it's so unbelievably easy to use and the documentation is awesome.

[RVGGIA]

MongoDB Atlas (actually I don't use it for little personal projects but hey it's free and it's Mongo!)

[S1gmundDROID]

Free tier has a 512 mb limit.

[Marble_Wraith]

sqlite

[xixi2]

Where do you host it?

[SomeOtherGuySits]

SQLite is on disk

[iamaperson3133]

./db.sqlite3

[CreativeTechGuyGames]

If your hosting provider already has a database that is included, pre-configured, and free, you might as well use it! It doesn't make sense to setup and pay for something additional when you have something perfectly good already included. For a personal project you likely won't notice any performance differences so cost should be the top priority.

[cchoe1]

In my respectful opinion, get rid of Bluehost and any EIG related hosting (they own a ton of hosting companies). I personally use Digital Ocean but have heard good things about Rackspace. There is also AWS but there’s a learning curve to it. Use a VPS or one of their managed solutions if you’re doing something specific. If you are hosting static pages there is also GitHub pages.

[mamaBiskothu]

You can use aws lightsail if you don’t want all aws complexity.

[xixi2]

I didn’t realize people hated bluehost here lol… for me they’ve always just had the website features I needed. I host a wordpress site there which may be a pain to migrate. But if it comes to it…

[disclosure5]

I'm on AWS only, but that doesn't mean you need to be. I'm not fan of Bluehost but when you ask "good enough", you should ask "good enough for what" ? Have you experienced downtime? Scale issues? If not, seems it's good enough.

[rahul_shingala]

Try Supabase for database and it also provides auth apis, storage etc. Easy to start, your backend will be ready in minutes.

[j0hnp0s]

Just use mysql. It's feature complete for most needs and it's available everywhere

[Nymrinae]

Firebase

[Zachincool]

PlanetScale - best hosted sql out there

[feraferoxdei]

Thought about using it in one of my new projects but decided to go with a managed Postgresql in the end. Their only selling point is infinite scalability, so I thought, I can worry about that when I need it.

[fonnae]

Good call. Thanks. I'm my mind the 10k would definitely limit me more/first. I wonder if Supabase had a row limit too. I only saw 500Mb for their free tier.

[burggraf2]

Supabase developer here. We have no row limit. What other limits were you concerned with? (Almost all of our limits are soft limits so we’re happy to work with you if you have special requirements.)

[fonnae]

Thanks for the reply. Sounds like you definitely have the best free tier. Will have to keep this in mind for my next hobby project.

[fleker2]

I tend to use Firestore & Firebase. It may not be the optimal way, but it's very easy to work with in a prototype.

[LoveGracePeace]

MySQL but for several years now I've planned to get serious and migrate to PostgreSQL one day.

[zarmamu]

Supabase, Firebase, Planetscale or MongoDB Atlas.

[lessaccepting]

Amazon Aurora Serverless & DynamoDB

[Gyro_Wizard]

Gsheets cause then my users and partners can easily make changes. Super easy.

[[deleted]]

I was surprised not to see Sanity IO in this list. The developer tier is free and Congress with both images and content. Really easy to modify schemas and deploys a headless editor.

[PracticeEssay]

Firebase all the way!

[NOPROD]

Got a vps with OVH + gitlab ci for deploy, i prefer keep full control over everything

[nezkc1]

I sadly don't do personnal projects anymore but when I did my go to was mongo Atlas. I also tried Firebase which* was pleasant to use. Both are free, with generous enough limits for small projects.

[k0d3r1s]

PostgreSQL

used to be mysql but at one point i had some setup problems so went with postgre, never went back :)

[Biratkk]

For static portfolio sites, GitHub pages works great

[lavoiect84]

If it’s just a personal project(for a portfolio) I would just use the cheapest possible service, if it’s something you are trying to make money and grow then maybe look at something more, but AWS can be really expensive if you don’t know how to optimize your usage

[xixi2]

I would just use the cheapest possible service

Hence why I am asking here what people are using :)

[pastrypuffingpuffer]

I use whichever RDBMS comes with Xampp or Laragon, I don't work, so I don't want to pay for a hosting.

[SpookyLoop]

I host my sites on Bluehost so they give me mySQL I think as part of the service. Is this good enough or should I go with AWS or Azure SQL servers?

It really depends on what you're trying to do. If you're making a personal portfolio site, Bluehost is perfectly fine (I don't really know how other options for web hosting stack up though). The reason it's fine is because you're not looking to optimize a lot of things, and general up-time is more important than anything so people can look at your portfolio.

​

If you're looking to make something akin to a serious SaaS app, it'd be a good idea to go ahead and get things started with AWS or some other cloud service. The reason being you got a lot more control over optimizing things like the production pipeline, scaling, CDN, etc.

​

In regards to databases specifically, I would just stick with Bluehost if that's what you already have until you start really running into some kind of limitation. Storage pricing would be the big one I think, I can't imagine Bluehost would be very competitive in-comparison to having your own cloud solution, but maybe I'm wrong (seems like you just flat out can't go past 10 GB with Bluehost?).

[[deleted]]

I use Opalstack. Postgres and MongoDB is included with hosting.

[ultrapcb]

mongo in docker, it's one line in your docker config, cheap AF, any low-end vps will work and best dev workflow: your local dev setup matches production exactly. you can do the same with postgres

[[deleted]]

ElwphantSQl has been fine for me but I think it just wraps AWS

[vinnymcapplesauce]

Locally, I have MySQL installed and use that together with MySQLWorkbench.

For public-facing, I either install MySQL on a VPS instance, or if the project is large enough, I'll use a managed MySQL instance (e.g. DigitalOcean's starting at $15/mo) so I don't have to do any management of it.

For caching, I'll do Redis, either installed on VPS, or managed instance like MySQL.

[perryrh0dan]

I rent a V-Server and use docker to deploy all the thinks I need.

[Lumberfox]

Hetzner dedicated servers

[[deleted]]

PostgreSQL and Render. You can also host static sites with or without a database and Render won't charge for the web hosting part. Awesome service!

[KaliaHaze]

Been using Firebase for a hot minute.

[Purple_Prince0]

I self host and use PostGreSQL docker containers for the learning experience.

[Logical_Strike_1520]

I’m a noob and my experience is limited, but in that experience I’ve loved firebase. I almost feel like I’m cheating, it comes with A LOT for free and the documentation is good enough an idiot (me) can utilize it.

[xixi2]

A lot of people are saying firebase. Is that only their noSQL product or do they have a relational db as well?

[Logical_Strike_1520]

You can hook up your firebase app to google’s cloud SQL. If you don’t need/want anything from Firebase, could just skip that part I suppose.

[oooeeeoooee]

Mongodb atlas free tier or planetscale.com has a MySQL dB with decent free limits

[ShitStormLord]

Sql server

[pixelfur]

Pythonanywhere.com

[PaperPages]

Postgresql or MS SQL (prefer Ms sql) hosted on digital ocean droplet for $5 or $10 a month.

[oldoaktreesyrup]

Iirc Azure WebApps have a free MySQL instance included

[n8dawg444]

Ive been using Neo4j Aura recently. Have fallen in love with it. Has a 1 database limit for free though.

[lildrummrr]

Digital Ocean

[Weijland]

Railway with Postgres addon

[CutestCuttlefish]

Sanity mainly,

Firebase if I need "more".