Hacker News new | ask | show | jobs
by pimbrouwers 1671 days ago
My best advice, try it! I have used it many times for server apps with great success, namely "forms-over-data" systems, some even with a large user base but low concurrency.

Some tips to make this work:

- use the latest version

- use write-ahead logging

- use synchronous execution model

- favor insert (and delete) over update

- favor many small, simple queries over larger, all-serving queries

- open and close connections quickly

- employ app level validation

- define a typed schema