soul

Some suggestions: The submitted page can add a link to the github repo. If it is already there it isn't obvious. As the links to /api/tables and others are throwing 404, I had to copy & paste the url from the dev snippet to see examples of the API. Running the server to view documentation helps in ensuring that the docs are current but it will also add unnecessary friction and deter those who want to just look at the API doc for evaluation. PS: The source url is https://github.com/thevahidal/soul

Hey everyone, I'm excited to share an update about Soul, an open source project I created that acts as a RESTful and realtime server for SQLite databases. Soul makes it incredibly simple to add a backend to any project - just give it a SQLite database file and it will instantly serve up CRUD endpoints without any additional configuration. When I first launched Soul a while back, its core functionality was just this. A few months ago, one of Soul's long time contributors approached me about adding authentication and authorization capabilities. We worked together to design an ACL system, and they implemented it. I'm pleased to share that Soul now has robust user authentication and role-based access control built right in. The authentication works by defining "roles" that map tables to permitted CRUD operations. These roles can then be assig

Hi Folks, For those who are not familiar with Soul it's a REST and realtime server as the title says, basically it takes an SQLite database file and gives you a set of CRUD APIs to interact with your db and also a websocket to subscribe to its changes. All the feature's up to here is automatic and you do nothing. But what if you wanted to create custom APIs to serve custom needs? Now that's available thanks to first member of Soul's Extensions, "API Extensions." With an syntax similar to Express.js, you can add new custom APIs to own your backend! Soon we'll be tackling new extensions such as middlewares and callbacks. So make sure to watch Soul's project. Here's the link to Soul repo: https://github.com/thevahidal/soul Let me know what you think about this new feature, And I'll see you in the next one.

Hi Folks, It's been an amazing journey since I first published Soul on HN and now I added a really major feature that Soul lacked, Realtime changes via Websockets. For those who are not familiar with Soul, it basically takes a SQLite database file and run a CRUD API on it, so you can have a minimal backend with no code. Now thanks to this new feature, users can subscribe to changes in a table and whenever a Create, Update or Delete operation happens, Soul will send the realtime data to subscribers. If you need some examples on how to work with websockets in Soul, you can find a bunch of examples here: https://github.com/thevahidal/soul/blob/main/docs/ws-example... Please let me know what you think of this new feature and also submit any issues you faced so we can fix them as soon as possible. Also if you have ideas to make Soul a better t

Hi Everyone, It's been less than a week since I showcased Soul on HN, and the support you showed was more than I ever could Imagine. Thank you! For those who are not familiar with Soul, it basically takes a SQLite db file and give a CRUD API to work with your database. One main feedback was to add good examples that people can find out how it works without looking too much. Now I added API examples for all endpoints which you can find here: https://github.com/thevahidal/soul/blob/main/docs/api-exampl... Let me know what else we could do to make Soul a better product, or if you faced any bugs or issues. Also I appreciate any kind of contributions! Thanks again, and I see you in the next one!