24 ms·

Serious question: If you take a BDD/TDD approach - do technologies like this still give you something? I've dabbled a bit into smth similar (SpacetimeDB) with

by Garlef 6mo ago

Serious question: If you take a BDD/TDD approach - do technologies like this still give you something? I've dabbled a bit into smth similar (SpacetimeDB) with the aim of creating a headless backend for a game. But then I realized that I'd still need to define the interface that I was testing in the traditional software layer and that all the nice DB magic seemed worthless since I'd still have to orchestrate traditionally. (In short: No matter how nice your DB magic is, you will still hide it away in the basement/engine room, right?)

ok_dad 6mo ago
Sounds like we need IDE support for databases like we have for programming runtimes. Need to be able to lint, debug live, etc.
- jjordan 6mo ago
  I've always passively wondered why this wasn't more of a thing. Something like pgAdmin is fine I guess, but it's always felt like "just barely good enough" rather than an immersive power tool to get things done, and done well. Possibly just a skill issue, but that's been my impression.
  - ok_dad 6mo ago
    No I get it; and it’s not a skill issue because debugging with proper tools is a skill and the issue is that lack of those tools means you lack the ability to even use your skill. My last job used a lot of fancy internal pg stuff and we could never really reason about it properly. I wish I could debug it like I do with a Go app with delve, or in my IDE. Adding NOTIFY everywhere is print debugging which in my opinion is not a very good debugging strategy.
mamcx 6mo ago
Check the dBase/FoxPro family. My nostalgia remember it fondly, and there was not disconnected in how everything worked (example: The forms were stored as tables, so you can do alike `SELECT * FROM form_name WHERE widget=`), and there was zero ORM. This is my aim https://tablam.org https://tablam.org. BTW I worked in SpacetimeDB and I proudly say is half-way :)

by Garlef 6mo ago

ok_dad 6mo ago

Sounds like we need IDE support for databases like we have for programming runtimes. Need to be able to lint, debug live, etc.

jjordan 6mo ago
I've always passively wondered why this wasn't more of a thing. Something like pgAdmin is fine I guess, but it's always felt like "just barely good enough" rather than an immersive power tool to get things done, and done well. Possibly just a skill issue, but that's been my impression.
- ok_dad 6mo ago
  No I get it; and it’s not a skill issue because debugging with proper tools is a skill and the issue is that lack of those tools means you lack the ability to even use your skill. My last job used a lot of fancy internal pg stuff and we could never really reason about it properly. I wish I could debug it like I do with a Go app with delve, or in my IDE. Adding NOTIFY everywhere is print debugging which in my opinion is not a very good debugging strategy.

mamcx 6mo ago

Check the dBase/FoxPro family. My nostalgia remember it fondly, and there was not disconnected in how everything worked (example: The forms were stored as tables, so you can do alike `SELECT * FROM form_name WHERE widget=`), and there was zero ORM. This is my aim https://tablam.org https://tablam.org. BTW I worked in SpacetimeDB and I proudly say is half-way :)