Sorry, we don't support your browser.  Install a modern browser

Optional, Native Database Storage#22

?

Flat-file is fast and flexible, but in the few cases when there’s thousands and thousands of records to search through, we do need a database: MySQL (available in most shared hosts) - or even SQLite would do. That’ll make Kirby suitable for ANY project.

a year ago
10

Isn’t that already possible with virtual pages?
https://getkirby.com/docs/guide/virtual-pages/content-from-database

a year ago

Possible, yes, but it still needs a lot of work to create the models and data structures. Would be great if this could be made easier somehow.

a year ago
6
?

Sometimes I have to use another CMS because when a site has 5,000+ users, I need a database. Trying to set everything up manually with Kirby and virtual pages is very hard, and feels like a ‘patch’ on the core. It would be great if we could have an option perhaps per blueprint, where we can choose how pages made with that blueprint get saved - like “storage: sqlite”. Don’t care if it’s an SQL or NoSQL database, as long as it works out-of-the-box.

a year ago
3

Okay, got it!

a year ago
1
?

If Kirby use database, then no need for any other CMS - please add this!

a year ago
2

a lot of things need to be considered like fake file modified checks, where to store uploaded files if not in folders.
maybe the core could put a file abstraction layer above the File and Dir classes used in classed inheriting from “Model” and these could either use real files, files from connected storages (S3 etc) or connect to a database.

a year ago
2
?

Uploaded files should stay in folders, like they are now - that’s best practice for databases (large blobs in databases are slow). The database table can be set to keep auto-updated ‘created date’ and ‘last modified date’ for its records - which are like ‘created date’ and ‘modified date’ for a page.

a year ago
?

Updating or deleting ‘linked’ records, like we do with SQL relationships on a database, can already be done in Kirby - even if it’s a bit of work, it can be done with hooks. But doing a QUICK SEARCH through 100,000 records simply can’t be done at all - and that is what we need. Let’s not even consider doing compound, boolean searches through multiple fields - in even just 10,000 records this can take more than 15 seconds. This means that Kirby can’t be used for sites that have tens of thousands (or more) of records, and there are a lot of sites like that. Like for example ecommerce sites with large product catalogs, community sites with thousands of users, blogs/forums with thousands of comments, photo galleries with thousands of images, etc, etc. It means that as a web developer, I can’t use “just Kirby” for all my jobs, and need to also know other CMSs that can handle large datasets with a fast database index. If I could just SEARCH QUICKLY through thousands of records in Kirby, I’d use Kirby for everything.

6 months ago
2

Integrating a fast search index into Kirby’s search is possible: https://getkirby.com/docs/reference/plugins/components/search
There’s even a plugin as @Code already wrote: https://github.com/distantnative/search-for-kirby

6 months ago

Native database as full-replacement is tricky (maybe not really “Kirby”-ish). One thing alone what’s supported on different servers - with Kirby we really aim to support a wider range of webhosting that is out there in the world.

But Bastian and I talked a few weeks ago that we think virtual pages are still the way to go and probably a lot more powerful than discovered by us and the community. We thought, maybe we could bundle some Page classes for common use cases - say ApiPage, CsvPage, SqlPage or so - that already adapt the class to work with such different sources than the filesystem. That could make it a lot easier for users to create virtual pages on top of e.g. a database.

5 months ago
9
?

That would be amazing to have in Kirby - and would be a game changer. I had to pass on a job because the site was going to have 100,000+ records, and I’m pretty sure searching was going to be far too slow in Kirby…

3 months ago

it might not be enough for 100k but with boost you can now speed up the content a lot.

https://github.com/bnomei/kirby3-boost

2 months ago
?

+1 to have fast database-like search in the core, please.

2 months ago
?

I have to redo a small WP site (bulletin board with less than 500 pages) that has 5000+ users - need this right now…

4 days ago

We at Kirbyzone could really use an ‘SqlPage’ right now, @Nico! ;-)

2 days ago