Fought a war with Django to migrate from sqlite to postgres. Documented the 'gotchas' I ran into in my latest video:

Why did I go through the effort to migrate everything from slqlite? To be honest, I didn't 'need' to use postgres. According to the sqllite documentation, it's perfectly fine to use it for websites this like mine.

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.

The goal of this site is to teach me how to design stable, scalable web applications that can handle large amounts of traffic. Blogthedata.com might not get over 100K hits/day, but it's very possible that my next position has me working on an application that experiences that kind of traffic volume.

Onward and upward!

Back to Home
 Profile Picture
Profile Picture

About John Solly

I am a Senior Software Engineer with a focus on geospatial applications, based in the Columbus, OH metropolitan area. This blog is where I delve into the intricacies of GIS (Geographic Information Systems), offering deep dives into different components of the geospatial technology stack. For those who share a passion for GIS and its applications, you've found a spot to explore and learn.

Interested in collaborating or learning more about my work? Take a look at my portfolio for a showcase of my projects and expertise.

Comments

  • No comments yet.
Login to Comment