1. Magicu-L | Main
  2. Topics

Best Free / low cost SQL's for Magic & AWS?

Charles George
 

Doing some research..., I'm sure this has an easy and non-controversial answer :)...

What's the best free / low cost SQL (or non-sql) DB for Magic & AWS these days?
JK Heydt
 

I use MySQL Community Edition. Free and works with Magic Express license. Works great!
Craig Martin
 

So, this is a really interesting question to me.

My stealth project for April/May is to figure out how I can build and deploy the best Magic backend traditional-merge web application ever built based on the T3 stack.

It may not work. Then again, hey, it's me.

https://www.youtube.com/watch?v=kK-iR6g-V1g
I was tired of all the pushback about cost I was getting, decided to rant about it. AWS is cheaper in the literal dollar per compute sense, but it is way more expensive than you think. Keywords: Vercel nextjs planetscale supabase aws amazon web services ALL MY VIDEOS ARE POSTED EARLY ON PATREON https://www.patreon.com/t3dotgg Everything else ...
www.youtube.com

From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Charles George <Charles73@...>
Sent: Wednesday, March 29, 2023 11:44 AM
To: main@magicu-l.groups.io <main@magicu-l.groups.io>
Subject: [magicu-l] Best Free / low cost SQL's for Magic & AWS?
 
Doing some research..., I'm sure this has an easy and non-controversial answer :)...

What's the best free / low cost SQL (or non-sql) DB for Magic & AWS these days?

steve stevenworthington.com
 

I’m going to chime in here! Realistically using any of the relation database services on AWS is not an inexpensive proposition. If you are looking for “cheap” and AWS in the same sentence you are going to the wrong place! Getting a vanilla instance at AWS and installing a database such as MySQL or Postgres that you are going to manage is an option that will be less expensive, but realistically you are not just going to host a single instance on an AWS server. You are going to need all the other public cloud system components; public IP, storage, network, backup, ingress and egress charges, security and probably at minimum a “landing zone” and maybe AD or some other form of authentication.

All “food for thought”!

Steve Worthington 

On Apr 2, 2023, at 4:23 PM, Craig Martin via groups.io <craig@...> wrote:


So, this is a really interesting question to me.

My stealth project for April/May is to figure out how I can build and deploy the best Magic backend traditional-merge web application ever built based on the T3 stack.

It may not work. Then again, hey, it's me.

https://www.youtube.com/watch?v=kK-iR6g-V1g
I was tired of all the pushback about cost I was getting, decided to rant about it. AWS is cheaper in the literal dollar per compute sense, but it is way more expensive than you think. Keywords: Vercel nextjs planetscale supabase aws amazon web services ALL MY VIDEOS ARE POSTED EARLY ON PATREON https://www.patreon.com/t3dotgg Everything else ...
www.youtube.com

From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Charles George <Charles73@...>
Sent: Wednesday, March 29, 2023 11:44 AM
To: main@magicu-l.groups.io <main@magicu-l.groups.io>
Subject: [magicu-l] Best Free / low cost SQL's for Magic & AWS?
 
Doing some research..., I'm sure this has an easy and non-controversial answer :)...

What's the best free / low cost SQL (or non-sql) DB for Magic & AWS these days?

Charles George
 
Edited

Here's what Bard has to say...
----------------------------------------------------------------

MySQL, SQLite, and PostgreSQL are three of the most popular open-source relational database management systems (RDBMS). They each have their own strengths and weaknesses, and the best choice for a particular application will depend on the specific requirements of that application.

MySQL is the most popular RDBMS, with a market share of around 45%. It is easy to use and has a large community of users and developers. MySQL is a good choice for small to medium-sized applications that do not require a lot of performance or scalability.

SQLite is a smaller, embedded RDBMS that is designed to be used in applications where size and performance are critical. SQLite is used in a wide variety of applications, including mobile devices, embedded systems, and web applications. SQLite has a market share of around 3%.

PostgreSQL is a full-featured RDBMS that is comparable to commercial RDBMS such as Oracle and Microsoft SQL Server. PostgreSQL is known for its reliability, scalability, and flexibility. PostgreSQL has a market share of around 15%.

The following table summarizes the key differences between MySQL, SQLite, and PostgreSQL:

Feature MySQL SQLite PostgreSQL
License GPLv2 Public Domain BSD
Size 3-5 MB 250 KB 20 MB
Performance Good Excellent Excellent
Scalability Good Excellent Excellent
Features Full-featured Basic Full-featured
Community Large Small Large
Market share 45% 3% 15%

Ultimately, the best choice of RDBMS for a particular application will depend on the specific requirements of that application. MySQL, SQLite, and PostgreSQL are all good choices, but they each have their own strengths and weaknesses.
----------------------End 'o Bard----------------------------------------------
To prioritize performance and keep costs low, it looks like SQLite on a vanilla instance at AWS may be the way to go to get started and then move up to PostgreSQL if needed.
Craig Martin
 

I'm just looking forward to the day when AI does all the development and deploys to an audience comprised only of AI bots that do all the work without human interaction - and I can just ride my bike.

Wait, that day already arrived.

From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Charles George <Charles73@...>
Sent: Monday, April 3, 2023 10:09 PM
To: main@magicu-l.groups.io <main@magicu-l.groups.io>
Subject: Re: [magicu-l] Best Free / low cost SQL's for Magic & AWS?
 

[Edited Message Follows]

Here's what Bard has to say...
----------------------------------------------------------------

MySQL, SQLite, and PostgreSQL are three of the most popular open-source relational database management systems (RDBMS). They each have their own strengths and weaknesses, and the best choice for a particular application will depend on the specific requirements of that application.

MySQL is the most popular RDBMS, with a market share of around 45%. It is easy to use and has a large community of users and developers. MySQL is a good choice for small to medium-sized applications that do not require a lot of performance or scalability.

SQLite is a smaller, embedded RDBMS that is designed to be used in applications where size and performance are critical. SQLite is used in a wide variety of applications, including mobile devices, embedded systems, and web applications. SQLite has a market share of around 3%.

PostgreSQL is a full-featured RDBMS that is comparable to commercial RDBMS such as Oracle and Microsoft SQL Server. PostgreSQL is known for its reliability, scalability, and flexibility. PostgreSQL has a market share of around 15%.

The following table summarizes the key differences between MySQL, SQLite, and PostgreSQL:

Feature MySQL SQLite PostgreSQL
License GPLv2 Public Domain BSD
Size 3-5 MB 250 KB 20 MB
Performance Good Excellent Excellent
Scalability Good Excellent Excellent
Features Full-featured Basic Full-featured
Community Large Small Large
Market share 45% 3% 15%

Ultimately, the best choice of RDBMS for a particular application will depend on the specific requirements of that application. MySQL, SQLite, and PostgreSQL are all good choices, but they each have their own strengths and weaknesses.
----------------------End 'o Bard----------------------------------------------
To prioritize performance and keep costs low, it looks like SQLite on a vanilla instance at AWS may be the way to go to get started and then move up to PostgreSQL if needed.
steve stevenworthington.com
 

Don’t forget SQLite is single user 

Steve Worthington 

On Apr 4, 2023, at 12:09 AM, Charles George via groups.io <Charles73@...> wrote:



[Edited Message Follows]

Here's what Bard has to say...
----------------------------------------------------------------

MySQL, SQLite, and PostgreSQL are three of the most popular open-source relational database management systems (RDBMS). They each have their own strengths and weaknesses, and the best choice for a particular application will depend on the specific requirements of that application.

MySQL is the most popular RDBMS, with a market share of around 45%. It is easy to use and has a large community of users and developers. MySQL is a good choice for small to medium-sized applications that do not require a lot of performance or scalability.

SQLite is a smaller, embedded RDBMS that is designed to be used in applications where size and performance are critical. SQLite is used in a wide variety of applications, including mobile devices, embedded systems, and web applications. SQLite has a market share of around 3%.

PostgreSQL is a full-featured RDBMS that is comparable to commercial RDBMS such as Oracle and Microsoft SQL Server. PostgreSQL is known for its reliability, scalability, and flexibility. PostgreSQL has a market share of around 15%.

The following table summarizes the key differences between MySQL, SQLite, and PostgreSQL:

Feature MySQL SQLite PostgreSQL
License GPLv2 Public Domain BSD
Size 3-5 MB 250 KB 20 MB
Performance Good Excellent Excellent
Scalability Good Excellent Excellent
Features Full-featured Basic Full-featured
Community Large Small Large
Market share 45% 3% 15%

Ultimately, the best choice of RDBMS for a particular application will depend on the specific requirements of that application. MySQL, SQLite, and PostgreSQL are all good choices, but they each have their own strengths and weaknesses.
----------------------End 'o Bard----------------------------------------------
To prioritize performance and keep costs low, it looks like SQLite on a vanilla instance at AWS may be the way to go to get started and then move up to PostgreSQL if needed.
Pavel Mencl
 

I'm curious about this. How would I support multiple users with Magic? Because, as Steves mentions, Magic documentation says that SQLite is single user only.
Pavel

Is the SQLite database good for multiple users?
 
 
Yes SQLite can support multiple users at once. It does however lock the whole database when writing, so if you have lots of concurrent writes it is not the database you want (usually the time the database is locked is a few milliseconds - so for most uses this does not matter).

1 - 8 of 8