Better-sqlite3 causing 500 server error

[johmcg64]

https://arthur-treacher-fish-and-chips.netlify.app
development platform: nextjs 14
500 server error
no netlify production build problems
local production build and deployment works fine. The 500 server error does not show

cause of error: const db = new sql(‘posts.db’); after I try to submit the form

[nathanmartin]

@johmcg64 You didn’t say where the error is occurring, but I’ve clicked around and I presume you mean this page: https://arthur-treacher-fish-and-chips.netlify.app/items/ProcessContactForm

Check your Function logs:

Function logs

[johmcg64]

Hi, can I store the database on netlify.com server. They database may grow.

Thank you for your help.

John

[nathanmartin]

@johmcg64 That’s hard to answer, as Netlify isn’t a traditional server environment.

See:

Does netlify support SQLite?

Hi, @zonetecde. You can use SQLite in both functions and during the build and deploy process. There is no application server at Netlify so to run code after the deploy it must be done in functions (or edge functions). That said, SQLite is supported in the places where your code can run (the build system, functions, and edge functions).