Manual talk:SQLite

Old discussions

Previous page history was archived for backup purposes at Manual talk:SQLite/LQT Archive 1 on 2015-07-10.

This may be more of a Linux question, but how can I access a database file stored on a network drive? I'd like to use Mediawiki for work-related stuff, but the company IT department is not keen on running a Linux server, let alone an SQL server. I can set up my own Linux webserver, but I'll have to store the mediawiki database on the network, as well as storing all the "image" files but that's another hurdle.

In general, you need to google "NFS tutorial" to learn how to set up this kind of stuff, however SQLite developers don't recommend using it with NFS. SQLite is a local database, after all.

The page says: Several extensions are known to have database update or installation issues with SQLite: AbuseFilter, Echo, Flagged Revisions and LiquidThreads

On a test installation using SQLite, I tried installing Echo and Flagged Revisions. And they seemingly work successfully. So, what are the specific issues that we face? Is it something that surfaces after a while?

FlaggedRevs used to have problems... I *think* it's OK now after some patches.

I confirm Echo seems to work now.

I added Flow to the list, per T138316.

Hi All,

Are there any guidelines on size limitations within SQLite when hosting MediaWiki? This manual states,

"SQLite is not that scalable, so if you have a large and popular wiki, you should use MySQL."

I'm just looking for something more quantifiable for the words "large" and "popular", such as recommendations on:

• Maximum Database size
• Maximum concurrent users (for reading, or for making edits)

I currently host a MediaWiki instance on SQLite that's been running fine so far (albeit, searching is a little slow; occasionally general navigation slows down, too). While we have control over the number of users, the size and usage is gradually increasing, and I want to make sure that I can keep up.

Thanks

We don't have the statistics, which means that if you're asking these questions you're probably large and popular enough :) Seriously though, SQLite has never been intended for concurrent use so while simultaneous reads aren't a problem, writes just lock everything including reads too which might be the cause of sudden slowdowns you're experiencing. What are your exact size/usage numbers?

Hi MaxSem,

Thanks for getting back to me. Large and Popular is probably a bit of an overstatement in reality; I'm just keen to err on the side of caution, and make sure we don't get caught out :)

Our database size is currently around the 500mb mark, growing at a rate of around 50mb per month. We're open to around 750 users at the moment.

Although our users aren't on there constantly changing stuff at volume (at the moment, at least), we did find that when we were getting the initial bulk of our content on there, performance wasn't brilliant for those contributors. At that time there were only a couple of users, but they were making constant changes, and they were experiencing quite a bit of slowness, particularly in searches.

I'd say migrate to MySQL before it's too late.

Good call; that's the answer I was expecting! :)

Thanks