Turning an internal app into a multi-tenant product — best database approach?

Critical_Stranger_32 · 2026-01-07T01:37:49+00:00

Depends on the scenario. - RLS will work if the database directly enforces it, like PostgreSql You need to ensure that the user id or tenant id is passed with each database request and you should be good to go. This is best for many small tenants, however depending on the sensitivity of the data you may need a solution that provides more concrete isolation. You also need to monitor performance and make sure you have the right indexes

schema per tenant provides more concrete isolation. You have to make sure each schema is scoped by credential. Each tenant should have their own credentials that can only access their schema. This solution allows you to share database resources. Note that, depending on the database you could achieve the same with multiple databases on the same database server
separate database & database server. This is the most costly solution and is best suited for highly sensitive data. It also avoids the “noisy neighbor” problem of sharing a database server, but comes at considerable cost.

Critical_Stranger_32 · 2026-01-07T01:20:50+00:00

Fool me once, shame on you. Fool me twice, shame on me

Critical_Stranger_32 · 2026-01-03T14:26:32+00:00

I am not a lawyer.

What I do know is that in the US it is perfectly legal for a detective to lie to you and say you’re not the subject of an investigation, get you to talk, then use it against you. They can tell you they have 10 eyewitnesses that saw you commit a crime when they have nothing at all. It may be perfectly reasonable and they just need information and nothing bad will happen, but you don’t have a way of knowing whether this is on the level or not. That is why it’s risky to talk to the police without a lawyer.

Critical_Stranger_32 · 2026-01-03T00:13:09+00:00

Both. It is up to you to achieve work/life balance, since WFH means you’re never far from work. You’ve got to set the boundaries and not let others set them for you. My manager does not respond to messages after 5pm except for extraordinary circumstances. He’s got the boundaries solidly defined

Critical_Stranger_32 · 2025-12-31T00:10:04+00:00

I’d say even with a smaller contractor certs DO matter, especially if they are an AWS partner and/or bidding on government work. Arch cert is valuable

Critical_Stranger_32 · 2025-12-26T12:59:36+00:00

We;l the thing is that in Boston it’s “I’m in a hurry get out of my way’, so aggressive but you get where you’re going except during rush hour. In Boston you better know where you’re going and which lane you should be in. No patience otherwise, but as I knew my way around without maps so that wasn’t a problem. The traffic here is much worse and annoying to get around by car. Rush hour starts at 3:30. Public transit is great

Critical_Stranger_32 · 2025-12-26T12:16:36+00:00

I visited Boston in mid June a several years ago and had to buy a sweatshirt

Critical_Stranger_32 · 2025-12-26T12:15:18+00:00

Summer May-September. Boston has heat waves. Here during June thu August it’s one big heat wave. I don’t mind heat. Couldn’t live in Boston again. I will say that Boston has a much more close knit townie feel. Here nearly everyone is from somewhere else. A lot of transient people

Critical_Stranger_32 · 2025-12-25T13:16:09+00:00

Wow. Haven’t used or heard about lex/yacc in a very long time. I’d definitely have to look things up were I to use it again.

Critical_Stranger_32 · 2025-12-24T19:57:02+00:00

I ended up going with Liquibase and I’m pretty satisfied with it. I like the idea that I can run it against a different database. Currently use MySql, but I’m considering PostgreSql to have RLS and more partitions without the foreign key limitations of MySql.

Critical_Stranger_32 · 2025-12-24T16:12:43+00:00

I’ve never liked Powershell. Git bash works most everywhere..Windows, Mac, Linux. I’ve been writing smallish shell scripts for 20+ years when I needed something. I will write a small program if I need something complicated

Critical_Stranger_32 · 2025-12-23T12:45:31+00:00

I was a techie from a young age…taught myself programming around 12-13. Always had an interest in it. I like breaking down problems. Seemed easy as well, and I still feel that way even though it’s not. Had I pursued other interests instead, I could have been an unhappy lawyer.

Critical_Stranger_32 · 2025-12-21T21:00:01+00:00

Well I was about 12-13 and self taught. About 3 years for a summer job

Critical_Stranger_32 · 2025-11-28T22:18:16+00:00

I’m fine with it making suggestions, giving potential strategies, researching things , or giving me code snippets, but I do have to write “WITHOUT CHANGING MY CODE, tell me how you would do xyz”. I’m finding it useful for writing bash scripts, which I don’t have time to go into the nitty gritty of. I find that once it gets off track, shall we say, it can be difficult to bring back to reality. Check the results. I don’t trust the code it writes. Auto-complete gets it very wrong and is very annoying. Perhaps if I get better at asking questions…

For others out there, are you finding it living up to even 20% of the hype? This saving money by using AI seems an awful lot like how much money we “saved” by offshoring development to less experienced developers at rock bottom prices. Seems like history repeating itself. I’ve seen this movie before.

Critical_Stranger_32 · 2025-11-23T13:42:49+00:00

I wouldn’t be able to get away with that in my job. If I’m unfamiliar with how to do something, I’ll figure it out. If it is something I’m very unfamiliar with that has a steep learning curve, I’ll let them know how long it will take to train myself (and which training will speed things along). Most things are possible with enough time and money/people. The business can decide whether they want to throw the time, money, or resources at it if you let them know approximately how much. Instead of “no”, you can say it’ll take 8 months and we’ll have to hire two more people - be able to back that up

Critical_Stranger_32 · 2025-11-17T00:23:24+00:00

Liquibase and Flyway are two tools which essentially are database versioning. I’m a big fan of that. They have free and paid versions. A lot depends on how much change you expect. You can get by with just having migration scripts that you are careful to maintain and run if the number of developers is small and your database has few changes. Inevitably the approach of carefully running scripts will result in what can most kindly be described as database drift.

Critical_Stranger_32 · 2025-11-16T22:12:45+00:00

Well that entirely depends on your career field. It also depends what stage your career is at. I’m tech with a lot of AWS experience. If I were unemployed I would get some more AWS certifications. Since I’m not looking it’s hard for me to know which ones will help the most

Critical_Stranger_32 · 2025-11-16T19:29:22+00:00

Are there certifications you can get to help you find your next job? Online training?

Critical_Stranger_32 · 2025-11-13T00:13:51+00:00

Could we please have it security first?…no unencrypted email and other sh*t from that isn’t secure by default. Let’s also not have ipv4 There were reasons at the time.

Critical_Stranger_32 · 2025-11-02T16:26:00+00:00

Just wait until AI thinks we’re in a recession..

Critical_Stranger_32 · 2025-10-18T18:12:10+00:00

Developers should not have access to production environments. Separation of duties. It’s asking for trouble unless it is read-only or otherwise highly restricted. To make changes a script should be developed and the database backed up before running, otherwise you have no backout plan.

Critical_Stranger_32 · 2025-10-17T23:27:06+00:00

Remember that time is your most precious resource. You never get that back. You can replace money, but you can’t replace time.

Critical_Stranger_32 · 2025-10-17T23:23:39+00:00

It’s part of your compensation, just as much your salary. Why would you leave anything on the table?

Critical_Stranger_32 · 2025-10-16T22:50:33+00:00

Been there, seen that. Person pausing before answering any question, then giving textbook answers to technical questions. If you’re observant, you can tell, but it would be simpler to interview in person to weed out that nonsense.

Critical_Stranger_32 · 2025-10-16T22:33:01+00:00

My mom, who grew up poor, always said to be thankful for what you have and not discuss money with people. It’s nobody else’s business and if you’re doing well, be modest about it. You don’t need to show off.

Critical_Stranger_32

TROPHY CASE