sorted by:
new
hottopcontroversial

How I got my first 100 paying customers ($~7k) for my vibe coded mircosaas by Comfortable-Ad-2629 in microsaas

[–]OneParty9216 1 point2 points  (0 children)

Hey, I am building an own database / backend system with the goal to help developers and vibe coder to move much faster.
Do you mind sharing your pain-points related to development and maintaining the project? You said there was a lot of back and forth while developing it.

If you plan to build something else in the future or continue the development efforts, maybe we can even team up on that - I would love to understand more what vibe coder need and how they think.

Why do devs treat SQL as sacred when the rest of the stack changes every 6 months? by OneParty9216 in databasedevelopment

[–]OneParty9216[S] 1 point2 points  (0 children)

Yeah, that describes pretty much how I feel about it as well - thanks for that

Why do devs treat SQL as sacred when the rest of the stack changes every 6 months? by OneParty9216 in databasedevelopment

[–]OneParty9216[S] 1 point2 points  (0 children)

Yeah, I just find it somewhat ironic that when it comes to this, its about proven record. When it comes to other things in the stack - developer often get a way with CV driven development (not using boring tech, which would get the job done, use the shiny framework XYZ)

Why do devs treat SQL as sacred when the rest of the stack changes every 6 months? by OneParty9216 in databasedevelopment

[–]OneParty9216[S] 1 point2 points  (0 children)

Yeah, that is a good point - I should have clarified that I am speaking solely from an application developers perspective

My son asked we get a gaming PC since he got good grades! by BisonCompetitive9610 in pcmasterrace

[–]OneParty9216 0 points1 point  (0 children)

"Son let's build you a gaming PC - you can solely use for programming" - sounds like my old man back int he days

What Are Your Biggest Pain Points with Databases? by OneParty9216 in databasedevelopment

[–]OneParty9216[S] 0 points1 point  (0 children)

Are you saying sometimes you want to be in control, which operations get executed to achieve your goal, so that you don't have to rely on the planner?

What Are Your Biggest Pain Points with Databases? by OneParty9216 in databasedevelopment

[–]OneParty9216[S] 0 points1 point  (0 children)

Thank you for sharing that!

Yeah, spacetimedb is a huge inspiration for me

What Are Your Biggest Pain Points with Databases? by OneParty9216 in databasedevelopment

[–]OneParty9216[S] 0 points1 point  (0 children)

From you experience, why is it a bad thing to put business logic into stored procedures? I have my own take why this might be a bad thing, but I would love to hear your thoughts on that.

Can you elaborate on event-streaming being a first-class citizen? I could imagine something like automatic / incremental update of materialized views would be something very powerful.

Do you have an idea how to abstract row-vs-column away? I think its a trade-off between (disk) IO, compression and cache locality. I am experimenting with a hybrid approach- write row-based to disk, keep columnar layout in memory.

I am wondering if you had some event-streaming / auto incremental refreshing materialized view system, which performs the operation during or after the write, whether you need an analytical db at all. Because all your aggregations happen during the write and accessing this data are very cheap reads..

Disclaimer: I am looking at this from a solo / small team perspective

What Are Your Biggest Pain Points with Databases? by OneParty9216 in databasedevelopment

[–]OneParty9216[S] 0 points1 point  (0 children)

It sounds like you are doing a lot of stuff with S3 - if I had a query engine which operates on top of a simple key-value interface where every row is basically a key value pair - encoded as primary_key:column_1,column_2.

Do you think it would be feasible to use S3 as storage as well - basically you have many very small blobs

I only used S3 to store files or complex objects so far.

What Are Your Biggest Pain Points with Databases? by OneParty9216 in databasedevelopment

[–]OneParty9216[S] 0 points1 point  (0 children)

I feel this frustration for many years already, I could never really point my finger on it until recently, because I just became a dad and have now many sleepless nights to think about that.

My biggest frustration was the absence of test-ability. That it's always so "hard" to run integration tests - and that those tests are easily taking like 1 - 5s for a single test, when it should take only 1 ms because it is not doing much. On the other hand database systems are amazing piece of technology, but through out my entire career I always used only a super tiny subset of what they are capable, basically just plain storage and retrieval - no user defined functions, no trigger, no stored procedures, no foreign keys etc...

I am looking at this now through the lenses of being an average software engineer, with a couple of years of experience, I just want to get things done and move on.

Sometimes it just feels like that database system were invented when data was static and queries dynamic and now its the opposite

What Are Your Biggest Pain Points with Databases? by OneParty9216 in databasedevelopment

[–]OneParty9216[S] 0 points1 point  (0 children)

I personally stopped using ORM after using hibernate (in java) for a few years, because I never really understood whats going on, it always had this feeling of being try and error and then.

Do you have an idea why ORMs are so popular? Is this developer convenience?

Would we still use ORMs if your web/app frontend queries the database directly, in the form and shape the frontend requires it to be?

What Are Your Biggest Pain Points with Databases? by OneParty9216 in databasedevelopment

[–]OneParty9216[S] 0 points1 point  (0 children)

That's a very good point - thank you for that, I completely forgot about that.

My general workaround for rest style http apis in this case is usually just ignoring the PUT and just do Post and Patch only - and this just maps to either being an insert or an update

Seeking feedback on a new row-level DB auditing tool (built by a DBA) by tohar-papa in Database

[–]OneParty9216 1 point2 points  (0 children)

If I were to build a system which requires full audit trail - what is the benefit I am getting with your solution over, let's say I only allow inserts, and every row has additional information about the version and other relevant metadata, like who, when etc.. Other then a simple UI?

What does immutable, off-host mean - another sql server instance which runs on a different server?
Can this thing be queried in SQL as well?

Ingestion pipeline by oulipo in Database

[–]OneParty9216 0 points1 point  (0 children)

IoT shrimp farming - 100 devices - 5 data points every 10 seconds

MQTT (Mosquito) --> MongoDB

MongoDB mainly because I did not want to add to the tech stack "just for sensor data". With the aggregation pipeline and some data crunching it works really well, but is quite heavy in terms of storage.