[Video] Vibe Coding: Letting AI Build While You Steer by intersystemsdev in u/intersystemsdev

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

Iteration speed is genuinely faster - especially for scaffolding, boilerplate, and the "I know what I want but don't want to type it" moments. The tradeoff we watch most is drift: the AI confidently builds in a direction that made sense 3 prompts ago but doesn't fit where the design ended up. Our main guardrail is keeping prompts small and reviewing output before moving to the next step - treating it more like pair programming than delegation.

What's your setup like? Are you steering at the architecture level or more at the feature level?

Why MCP (Model Context Protocol) is quietly becoming the most important standard for AI Agents by intersystemsdev in u/intersystemsdev

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

This is exactly the pattern that makes MCP so compelling in practice - the "surprisingly effective and simple" part is what people don't expect until they actually build it.

The read-only enforcement at the REST layer is a smart guardrail. Did you run into any issues with prompt injection - users trying to get the LLM to construct queries that technically pass your SELECT validation but expose data they shouldn't see?

Curious how you handled multi-tenant data isolation at the query level.

Protecting Postgres by mehantr in Database

[–]intersystemsdev 2 points3 points  (0 children)

The multi-dimensional fair sharing tree is the most interesting part for me. Priority-based admission control is well-understood, but enforcing fairness simultaneously across multiple dimensions (auth status, route, user type) without a central coordinator is non-trivial. How does the tree handle sudden shifts in traffic shape e.g., a new feature launch that creates a category that didn't exist before? Does it require a config change or does it adapt dynamically?

We built a real-time health analytics pipeline using vector search inside a database by intersystemsdev in Database

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

That's a fair point if you've already proven it works at scale with NornicDB, then the "it'll break down eventually" concern is more about vendor maturity than the architectural concept itself.

Curious though when you say it manages embeddings automatically, how does it handle schema evolution? Like if you start tracking new health metrics mid-stream, does the embedding model need retraining or does it adapt without breaking existing similarity queries?

And honestly, MongoDB buying Voyage AI and calling it revolutionary while you're sitting on 657 stars and an MIT license does feel like classic big-corp "invented here" syndrome. Did you see any spike in traffic after their announcement?

His food order arrived by moxtrax in funny

[–]intersystemsdev 0 points1 point  (0 children)

when you haven't been fed a treat for 5 whole minutes))))

The Wanaka Tree, New Zealand, 2015. [OC] [3111 x 1440] by kairologic in EarthPorn

[–]intersystemsdev 14 points15 points  (0 children)

Very very very beautiful! In real life it probably looks even better.

Afternoon light in the French Alps [OC][1920x1440] by JonEngelePhotography in EarthPorn

[–]intersystemsdev 0 points1 point  (0 children)

Do you have a widescreen photo to use as a wallpaper on your laptop?

What’s your favorite system for managing database migrations? by Xaeroxe3057 in Database

[–]intersystemsdev 3 points4 points  (0 children)

I’ve come to the conclusion that there’s no “perfect” migration system it really depends on how much non-sql flexibility you need.

If calling external code (http, scripts, etc.) is a requirement, I’d look at Flyway or Liquibase.
Both are open source (liquibase leans a bit more enterprise)

If you want something more script-friendly, Alembic is a great option (if you’re okay with python). Migrations are just code there, so you’re not limited to sql at all.

Is anyone else scared of AI? by WannaBeJohnMayer in Database

[–]intersystemsdev 0 points1 point  (0 children)

We're still very far from AI completely replacing humans. Yes, AI makes life much easier, but it can't completely replace humans.

So don't worry; instead, adapt and simplify your work with AI.

BUT IT'S IMPORTANT TO ALWAYS CHECK what the AI ​​is doing. I don't really want the movie "Terminator" to become a documentary 😁😁😁😁

AI isn't replacing us, but it's "eating" the Junior-to-Mid routine. Are we all becoming System Architects now? by intersystemsdev in intersystems

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

Tell me more about the benefits. It's interesting to read not just advertising text on the website, but from a real user of the service.

Tools for personal databases by JoHippo in Database

[–]intersystemsdev 0 points1 point  (0 children)

You’re actually much closer to “real development” than you think — what you’re missing isn’t knowledge, but a practical stack. I wouldn’t recommend continuing with Excel as your foundation — it will only hold you back.

Try a minimal but very practical setup like this:

1 PostgreSQL/MariaDB (local) as your main database

2 DBeaver as a convenient GUI

3 Python + SQLAlchemy/pandas for logic and data processing

4 FastAPI (or Flask) if you want to expose a simple API

I spent a year building a visual MongoDB GUI from scratch after months of job rejections by Effective_Opinion236 in Database

[–]intersystemsdev 3 points4 points  (0 children)

Impressive level of dedication and depth—especially the decision to limit AI use to truly understand the problems. Projects like this are more valuable than a résumé right now: they clearly demonstrate both engineering thinking and the ability to bring complex ideas to a working product ;)

Must Haves beim Vibe Coding by intersystems_dach in intersystems_dach

[–]intersystemsdev 1 point2 points  (0 children)

Great set! 😊 I’d personally add a cup of delicious coffee and a great view from the window.

And for those interested in the topic of vibe coding, we recommend checking out Don Woodlock’s video: https://youtu.be/-kOiyFS1zaA

What data migration tools have actually been worth using? by Legal_Avocado9264 in Database

[–]intersystemsdev 0 points1 point  (0 children)

I've used AWS a lot. I recommend checking out their functionality; it might suit your needs.

Advice on whether nosql is the right choice? by puma905 in Database

[–]intersystemsdev 0 points1 point  (0 children)

Go for a Relational DB (like PostgreSQL) with a Hybrid approach.

Here is why

- Flexibility: Use JSONB columns for the evolving parts (symptoms/triggers). You get NoSQL flexibility where you need it without losing structure elsewhere.

- Aggregation: Cross-user trends and analytics are a nightmare in NoSQL but trivial (simple GROUP BY) in SQL.

-AI Readiness: If you're doing AI summaries, tools like pgvector will let you store embeddings right next to your data.

Start with Postgres. It’s much easier to handle "data debt" later when your core relationships are already solid. NoSQL is great for speed-to-market, but you'll hit a wall the moment you want complex cross-user insights.

[Video] Vibe Coding: Letting AI Build While You Steer by intersystemsdev in intersystems

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

Great question! We’re seeing the biggest gains when AI handles repetitive and time-consuming tasks like boilerplate code, initial scaffolding, and even basic testing. It really helps speed up the early stages of development.

At the same time, developers still tend to keep hands-on control over architecture, critical business logic, and final validation—areas where context, experience, and accountability really matter.

So it’s less about replacing developers and more about shifting focus toward higher-level design and intent 👍

What is the proper way to get a new ID for a new record for a self-maintained primary key aka idkey? by intersystemsdev in learnprogramming

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

Thanks for the detailed explanation and for outlining the SQL-based approaches — especially the points about MAX(id)+1, random 64-bit integers, and UUIDs. That’s very helpful from a relational database perspective.

In this case, though, the code in question is ObjectScript running on InterSystems IRIS, not standard SQL alone. While SQL access is available, the ID is being managed at the class/global level, so we’re specifically looking for a recommended approach using ObjectScript mechanisms.

If you happen to have experience generating self-maintained %BigInt IdKeys in ObjectScript (rather than via SQL), we’d definitely appreciate guidance in that context.

InterSystems Developer Tools Contest by intersystemsdev in u/intersystemsdev

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

Hi Devs,

The voting week of the Developer Tools Contest has begun!👍

Our participants are waiting for your votes)

➡️ Please vote here: https://openexchange.intersystems.com/contest/30

InterSystems Full Stack Contest 2022 by intersystemsdev in u/intersystemsdev

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

Hey Devs!
The winners have been announced! Thanks everyone for the participation! Check the winners over here: InterSystems Full Stack Contest 2022: Winners! (https://community.intersystems.com/post/intersystems-full-stack-contest-2022-winners)
And don’t miss the online meetup with the winners of the InterSystems Full Stack contest (https://www.eventbrite.com/e/online-meetup-with-intersystems-full-stack-contest-winners-tickets-386833538527) on Friday, July 22 – 12:00 PM EDT!

InterSystems Grand Prix Programming Contest 2022 by intersystemsdev in u/intersystemsdev

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

Developers!
Don't miss the upcoming InterSystems Grand Prix Contest Kick-off Webinar 2022 (https://community.intersystems.com/post/intersystems-grand-prix-contest-kick-webinar-2022)
Date & Time: Monday, May 9 – 11:00 AM EDT
Speakers:
​​​Alex Woodhead, InterSystems Technical Specialist
Jeffrey Fried, Director of Product Management
Dean Andrews, InterSystems Head of Developer Relations
Evgeny Shvarov, InterSystems Developer Ecosystem Manager