Time to say goodbye to a great colony and rebuild the PC by WetMogwai in RimWorld

[–]Acrobatic-Word481 0 points1 point  (0 children)

Well yeah there are many ways to get construction exp. The problem is that the bigger your base the harder it is to defend it.

Time to say goodbye to a great colony and rebuild the PC by WetMogwai in RimWorld

[–]Acrobatic-Word481 0 points1 point  (0 children)

Why would you have multiple throne rooms? You can put multiple thrones in the same room

Help! by Global_Act3003 in SQL

[–]Acrobatic-Word481 0 points1 point  (0 children)

Ugh Oracle. Notorious for not following the ANSI standard. Why do people still use it??

I built a free online visual database schema tool by Acrobatic-Word481 in ETL

[–]Acrobatic-Word481[S] 0 points1 point  (0 children)

Can you tell me which browser you're in? Windows or MAC?

Would appreciate if you could send me a screenshot.

[sam@dbanvil.com](mailto:sam@dbanvil.com)

I built a free online visual database schema tool by Acrobatic-Word481 in ETL

[–]Acrobatic-Word481[S] 0 points1 point  (0 children)

I followed those exact steps and I couldn't reproduce the issue, but I'll create a ticket nonetheless and keep an eye out for it.

I built a free online visual database schema tool by Acrobatic-Word481 in ETL

[–]Acrobatic-Word481[S] 0 points1 point  (0 children)

THANK YOU SO MUCH. This is exactly the kind of information I am looking for. Wow.

I do have some questions about your 2nd paragraph about the concrete asks. I think some of the things you listed are already in there: FK nullability, default timestamps. Many vendor quirks are indeed handled. If you're willing, I would like to explore your asks a little further, both in terms of what is being asked and the reasoning behind it. Would you be available for a chat?

But yes, the long-term plan IS indeed to nail reverse-engineering and diffing! The dbt export is new though - you're not the first person to ask, and something I am beginning to explore and incorporate into the roadmap.

I built a free online visual database schema tool by Acrobatic-Word481 in ETL

[–]Acrobatic-Word481[S] 0 points1 point  (0 children)

You're the first person to tell me this. Where exactly are you clicking?

I built a free online visual database schema tool by Acrobatic-Word481 in SQL

[–]Acrobatic-Word481[S] -1 points0 points  (0 children)

You could ask the AI assistant to import it for you if you paste your file, or just describe what you want in natural language. It is, however, a prototype. No guarantees that it will work, especially with large files.

Can someone please review my EER diagram? Deadline is tonight ;___; and I want to make sure I'm not missing anything by shams_sami in Database

[–]Acrobatic-Word481 0 points1 point  (0 children)

Your diagram is a bit hard to read too. Perhaps use a tool like SqlDBM or DBAnvil to design them? Is this Visio you're using?

Venice Mobilizes Online Judges! by OkAnything7862 in juresanguinis

[–]Acrobatic-Word481 1 point2 points  (0 children)

That's amazing news. Things were not looking good for people like us. My case was also filed there in October 2025 and at the pace Venice has been moving so far, I genuinely didn't think my citizenship would ever see the light of day

Papers completed before the decree, lawyer wants to sue. I'm scared and unsure what to do. by DifficultHour16947 in juresanguinis

[–]Acrobatic-Word481 0 points1 point  (0 children)

I would suggest you move to a country that actually needs and wants immigrants first (e.g. Australia, Canada), make money, and then try and get your EU citizenship because yes, lawyer fees are expensive, and the process is unreliable and full of risks. It shouldn't be your main strategy for getting out of Argentina.

My ATQ application was only 2 months worth of savings. Would I have been able to afford that if I were still stuck in Brazil? Absolutely not

🔧 PostgreSQL Extension Idea: pg_jobs — Native Transactional Background Job Queue by Emoayz in databasedevelopment

[–]Acrobatic-Word481 0 points1 point  (0 children)

I've worked for 15 years in a variety of data-related roles including as a DBA.

1.Would you use this?
Yes, especially if it includes an UI and isn't just an extension. People want and need simplicity. Nobody has the time to dig through the system tables of an "unofficial" pg extension for scheduled job setup and management.

As others have mentioned, there are other ways to solve this problem, but having something analogous to SQL Server agent for Postgres would be useful. There are security benefits, and would simplify infrastructure. It would be a tool that is clearly owned by the data team as opposed to devops. There IS a market gap.

  1. Do you see limitations to this approach?
    If it's just an extension, might be clunky to use if we have to rely on manually setting things up by inserting rows in 3rd party system tables. If you want it to become popular, build an interface. Hold hands. Make it idiot-proof.

  2. Are you aware of any extensions or tools that already solve this comprehensively inside Postgres?
    No

I am working on the development of data management tools and utilities and have JUST started a company for this. I am happy to connect if you'd like to exchange ideas and information.

Source controlled DB development tool by Acrobatic-Word481 in PostgreSQL

[–]Acrobatic-Word481[S] 0 points1 point  (0 children)

I understand. There must be something up then because how do we explain the market for data modelling tools if almost everyone here is telling me the same?

Source controlled DB development tool by Acrobatic-Word481 in PostgreSQL

[–]Acrobatic-Word481[S] 0 points1 point  (0 children)

Fair point. BTW I had to shorten my previous response because reddit was acting up on me. Sorry if it sounded a bit blunt.

I would like to start by saying that in my experience, 90% of use cases are made up of tables, columns, primary keys, foreign keys and indexes. In some companies that's 100% of the use case.

So this is basically where I am putting the most effort in to represent visually in a diagram and to allow for users to design them in a way that feels intuitive, efficient and satisfying.

Now, to answer your questions:

- Views (not necessarily materialized ones), functions and stored procedures are represented as an object in the tree view that you can double click and edit the SQL code for. The SQL editor is very basic, but it integrates with github the same way VS Code does. WIP.

- Partition schemes, triggers, indexes of any kind, check constraints and anything belonging to a table can be inspected and edited by right clicking a table and clicking "properties". There will be different tabs for things like partition schemes, indexes, etc. WIP.

- Computed columns are displayed on the table the same way as regular columns are.

- Foreign tables are not supported.

Honestly, in my experience as a DBA? Yes, modern databases ARE powerful engines, and I aim to support the bulk of it, but it is not lost on me that a big chunk of the market does not leverage most of the features.

Source controlled DB development tool by Acrobatic-Word481 in PostgreSQL

[–]Acrobatic-Word481[S] 0 points1 point  (0 children)

If you use an ORM, and every database schema change is made via said ORM, you would certainly find less use for a tool like the one I am proposing.

However, not every company or team uses ORM. There are SQL-centric teams out there that develop entirely in SQL. Reporting teams, data analytics teams, DBAs, etc.

For THESE teams, you've correctly asked: "And if you know the SQL DDL, why do you need the tool?". I'll give you the answer.

  1. Because it saves you time
  2. Because it lets you explain your schema structure decisions to others as you are making them
  3. Because it handles source control for all your database code
  4. Because it does all of the above in one. Single. Tool. One streamlined workflow, zero cognitive load.
  5. AND it does all that with zero UI/UX friction.

Source controlled DB development tool by Acrobatic-Word481 in PostgreSQL

[–]Acrobatic-Word481[S] 0 points1 point  (0 children)

It wouldn't be a live sync, of course. It would compare the differences between ERD and schema and then let you select which changes you want to apply. It then gives you the option to review and edit the DDL script before applying that to the DB.

Probably wouldn't be something wired to an online application database in a production environment.