Can I use sql3 to manage big site?

Question

0.00/5 (No votes)

See more:

hello everybody
so my question is can i use sqllite3 to manage a big project like shoping site?

What I have tried:

hello everybody
so my question is can i use sqllite3 to manage a big project like shoping site?

Posted 16-Jun-19 5:43am

Member 14145830

Updated 16-Jun-19 10:40am

Add a Solution

3 solutions

Solution 2

See overview here: best-open-source-relational-databases-for-high-performance-web-applications[^]
And also: Best open-source-relational-databases[^]
And: Best non-relational-databases-for-web-apps[^]

Posted 16-Jun-19 6:43am

RickZeeland

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thomas Daniels · Accepted Answer · 2019-06-16T05:49:00

Depends on how big you mean by "big". See Appropriate Uses For SQLite[^]. Under "Websites", they mention:

Quote:
SQLite works great as the database engine for most low to medium traffic websites (which is to say, most websites). The amount of web traffic that SQLite can handle depends on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic.

That's of course not the only factor, and I would recommend reading through the whole document before deciding whether SQLite is the best option for this project.

OriginalGriff · Accepted Answer · 2019-06-16T10:40:00

Quote:
can i use sqllite3 to manage a big project like shoping site?

Yes.
Should you? Would I? No.
The problem is that you probably have no idea how many users you will have when you start (none would be a good guess) and really no idea how many users in a years time.
And SqLite isn't scale-able, so the first time you find out it doesn't work well enough is when you are popular and can't afford to have the site fail, let alone find the time for a solid rewrite to use a more scale-able system.

Me? I'd probably start with SQL Server, or Azure rather than what is effectively a single user DB being used for multiuser access. At the very least, you get performance monitoring tools which might warn you that you need to consider scale before the site gets problems.

Can I use sql3 to manage big site?

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0