michael / editable-website

A SvelteKit template for building CMS-free editable websites
https://editable.website
MIT License
1.34k stars 103 forks source link

AMAZING! A few questions about performance and images #21

Open NafunaAfrica opened 9 months ago

NafunaAfrica commented 9 months ago

Hi there, Awesome project!

  1. I use svelte along with some other frameworks like skeleton. On an exisiting project, is it possible to add the functionality?

  2. Your thoughts on how many requests would be needed for SQLite before one needs a "Production" database. Most of my clients will have very low traffic.

  3. What happens to images? How are those edited?

  4. If this was a CLI that would patch existing sveltekit files it would be AWESOME!

  5. Does the blog run off the sqlite too? how does all this handle new posts and images? Multiple users for a small team to manage? How does blog section parse youtube video links?

  6. On hosts like digital ocean app platform, everytime i push a commit it will overwrite DB? So how do I make a longer term solution?

michael commented 9 months ago
  1. you can, it will just need manual labour :)
  2. No idea, we haven't been any close to hit the limits. But you could always beef up your server
  3. images are compressed on the clientside using WebP and then stored in SQLite as well
  4. That sounds like too much magic. ;) But who knows, maybe some AI can do it? :D
  5. Yes, it all runs off sqlite. A new blog post is just a new entry in the posts table.
  6. Don't know about DigitalOcean, but we have a decent setup working with Fly.io (see these instructions here: https://www.postowl.com/docs/administration-guide/deploy/)