Supabase’s Post

I was writing a super small API server which stores the data in Key-value pair (in RAM) and returned it back when requested. The problem I faced was I keep loosing the data whenever my API server restarts or crashes. To fix it I decided to write the data (key-value) in file along with storing it in memory. It solved my problem of loosing the data (sort of) at every restarts or crashes. The file I create is called WAL (Write Ahead log) file. Whenever my API server/db restarts/crashes, data is not lost. Question to you all: Even if I am using the WAL, I am still seeing the data loss. Can you guys think and share why? Hint: Does it has to do anything with the order of storing the data in RAM and WAL? Will answer in my next post.

Just pushed a new version of sqlaxe: added "table-drop" and "table-truncate" commands. The first adds DROP TABLE IF EXISTS before CREATE TABLE commands; this is helpful if you want to write over an existing database, such as in development. The second, similar command adds a TRUNCATE TABLE command before INSERT statements.

How to Get All Data from Multiple Databases Using API Maker 🚀

It is a very realistic production level question: How can you rename table, column(s) in SQL with zero down time? please check this stack-overflow question and first answer https://lnkd.in/eFdyKcpg

In the last couple of months, I built an alternative to a tool which has been discontinued (after acquisition). I believe it's a very useful tool to automate your database tasks through user actions and automated schedules. The basic gist is to allow your users/colleagues to run custom database queries through auto-generated and dynamic forms. Allowing them to run business related tasks without knowing how to write & use SQL. I believe that the version I published tonight is ready to be used by more people, hopefully gathering more feedback to fine-tune and improve on my initial ideas. Have a look: https://taskbee.dev 😎

New video! https://lnkd.in/eRKwn3rG How to generate REST & GraphQL API endpoints using Data API Builder in a few seconds

We've been rolling out features so fast, we forgot to mention the new import and export feature. This is useful for sharing data and/or schema definitions between different accounts and for importing data from other applications. The import feature is flexible and allows you to import either JSON files generated by Saasufy or raw JSON objects (e.g. like those typically exported from a spreadsheet). In the latter case, Saasufy automatically figures out and generates the schema definitions for you; you can then manually add more constraints on each field in the schema via the Saasufy control panel (e.g. size or format constraints).

#Spring_Data_REST: Say Goodbye to Controller and Service Spring Data REST module is the solution. Spring Data REST uses interfaces that extend JpaRepository and provides CRUD REST APIs for entities for FREE — Helps to minimize the boiler-plate controller layer code. https://lnkd.in/edYNu9ha

Using a separate Read and Write DbContext? It's possible. This makes perfect sense if you want to use separate data models for reading and writing to the database. Are you doing CQRS? ✅ Flexible queries? ✅ Rich domain? ✅ Watch this to learn how → https://lnkd.in/edvFEazU

Specific read and write DbContext #netcore #entityframeworkcore