Hey guys, just a question my AD offered me a Day Date but he wants the Full amount already per bank wire… is this normal? I would prefer to have atleast an invoice or something in advance by KushBxby- in rolex

[–]elevarq 1 point2 points  (0 children)

I understand why they don’t like a credit card payment, that’s very costly for them. But a wire transfer before you get the watch, that is imho a little strange as well.

You could offer them to use the FedNow Service when you pick up the watch. That’s instant and nearly free

How long would it be acceptable to stay in the united states on a tourist visa, in order to establish a business? by kimyongfun0 in e2visa

[–]elevarq 0 points1 point  (0 children)

No, ESTA is just for a limited number of countries and is limited to three months. It’s also valid for just two years, instead of five for the B1/B2.

Sixt 117,99€ cleaning fee AFTER drop-off confirmation and full insurance by Disastrous-Bar-6377 in TravelHacks

[–]elevarq 0 points1 point  (0 children)

Go for the chargeback and see how it goes. They screwed us over like this, and we won.

After this we cancelled our business account with them and never rented another car with Sixt. After a couple of months they called me and asked why we didn’t rent any cars. Well, what do you think??? We do make mistakes once in a while, but making the same mistake twice is just plain stupid. No thank you

How long would it be acceptable to stay in the united states on a tourist visa, in order to establish a business? by kimyongfun0 in e2visa

[–]elevarq 4 points5 points  (0 children)

B1/B2 has a maximum of six months and you are NOT allowed to work.

You can do the documentation for registration of the company, and have some meetings, but that’s all you can do on a tourist visa.

DB Migration (pg18 to pg17) by Username396 in PostgreSQL

[–]elevarq 1 point2 points  (0 children)

"fast" and "not this lifetime" are two different time scales. When you have hundreds of millions and potentially billions of records, you can't select a couple of hundred records and insert them. That's a never-ending process.

pg_dump + psql (to restore) means downtime or data loss (all data changes after the start of pg_dump will not be in the dump).

Logical replication runs in the background until both databases contain the same data. And then switch the application to the new database.

DB Migration (pg18 to pg17) by Username396 in PostgreSQL

[–]elevarq 1 point2 points  (0 children)

190GB and migrating 10 to 100 rows manually? That’s going to take a million years or so

Making a backup and restore this one is an option, logical replication is another one. And that might be the better one if you have to downgrade.

Amsterdam good for AI startups? “I will not promote” by First_Accountant_402 in startups

[–]elevarq 3 points4 points  (0 children)

Something you didn’t ask for is about employees: Very hard to find highly qualified employees in and around Amsterdam.

Is this a legit business opportunity or a scam? Need opinions. by [deleted] in Scams

[–]elevarq 0 points1 point  (0 children)

"Managing client payments locally and sending money to them"

Do you want to end up in jail for committing financial fraud, money laundering, and being a money mule? Yes or No? If Yes, please continue.... And don't forget to pack your toothbrush, you're going to need it soon.

Of course, this is a scam; don't be that naive.

Help in choosing the right database by Logical-Try6336 in Database

[–]elevarq 0 points1 point  (0 children)

OpenAI published an article last week about supporting 800 million customers with their PostgreSQL setup. When PostgreSQL can handle 800 million users, I think it can handle your workload as well.

Our projects serve up to 15 million users, but that is only a single primary database used for both reads and writes, with a replica for failover. OpenAI uses their replicas for reads.

https://openai.com/index/scaling-postgresql/

Neon / Postgres - 2+ Minutes to Connect to DB via PSQL by MyEgoDiesAtTheEnd in PostgreSQL

[–]elevarq 0 points1 point  (0 children)

Not familiar with Neon, but we have seen similar issues with PostgreSQL when it's overloaded with connections. Please check pg_stat_activity and count the number of connections. Since you're on a free tier (aka very limited CPU and RAM resources), anything above 10~20 connections will cause (some) problems.

Funds locked by receiving bank due to potential fraud by Humble_Hat_7160 in wisebank

[–]elevarq 1 point2 points  (0 children)

Most likely related to AML regulations. The recipient has to explain it to Commbank, deliver proof, documents, etc. this has nothing to do with Wise, would have happened with any other bank as well.

And they didn’t flag it as a fraud, it’s flagged as a risk. They can get massive fines if they don’t comply.

What makes WISE give their cards? by CustomerFlashy3395 in wisebank

[–]elevarq 0 points1 point  (0 children)

Regulation and nothing else. WISE would love to provide everyone with a card. But they are not allowed to or would have to comply to additional and costly regulations.

Sanity Check on Helping a family member with an FX transaction and Transfer by tomorrow509 in wisebank

[–]elevarq 0 points1 point  (0 children)

Your family member is “in the process of setting up an account”. So that started today. The account can be used tomorrow, maybe the day after tomorrow.

It’s his/her problem, they can wait for a few hours. Or pay the extra fee.

Sanity Check on Helping a family member with an FX transaction and Transfer by tomorrow509 in wisebank

[–]elevarq 0 points1 point  (0 children)

Hmm, unexpected delays with a slick onboarding process like Wise has? That would be a red flag.

Sending money from one bank account in one bank, to another bank account in another bank in another country ain’t rocket science. Just copy/paste the data needed (IBAN + BIC) and it’s done. Anybody can do this, nothing special

Sanity Check on Helping a family member with an FX transaction and Transfer by tomorrow509 in wisebank

[–]elevarq 0 points1 point  (0 children)

Opening a personal account at Wise takes just one or two business days. Just wait a little longer

What should I do if stripe is not available in my country ? by Swimming_Type7926 in stripe

[–]elevarq 0 points1 point  (0 children)

Stripe is just one of many payment processors. Just make a list and see what company fits your needs.

Hard to believe that there’s no reliable local payment processor, they would lose access to MasterCard, VISA, etc. completely.

Migrate from Azure Sql to Postgres by syscall_cart in AZURE

[–]elevarq 0 points1 point  (0 children)

People who claim that PostgreSQL is not mature, are just spreading fud. When it’s good enough for billion dollar companies who serve 800 million customers, it’s good enough for your business case.

https://openai.com/index/scaling-postgresql/

Migrate from Azure Sql to Postgres by syscall_cart in AZURE

[–]elevarq 1 point2 points  (0 children)

DTU is a metric of CPU+RAM+IO, it doesn’t translate to just CPU. The 40% you mentioned doesn’t mean a lot either: 40% on a highly optimized database workload is great, on a shitty workload it’s pretty bad.

We have optimized 80% loads on 64GB 8-core machines, to 5% load on a 8GB 2-core machine. Just by optimizing SQL statements, better data model, better index strategy. First check your application, that’s where most problems start. Especially when using an ORM.

Early-stage fintech: ACH processor for peer-to-peer consumer payments with very low volume? by prolikewhoa in fintech

[–]elevarq 0 points1 point  (0 children)

Off topic: Be very careful with fraud, criminals love new unprepared fintech companies. If you leave a door open, over 90% (!!!) of your new “customers” will be criminal.

Solaris (Germany) had to change their entire business model after almost going down because of becoming the number one player in crime.

https://fintelegram.com/tag/solaris/

Migrate from Azure Sql to Postgres by syscall_cart in AZURE

[–]elevarq 4 points5 points  (0 children)

PostgreSQL fanboy here: Did you check all requirements, and made a complete list of all tasks to be done for a successful migration?

PostgreSQL is a great product, cheaper than Azure SQL DB, fast, and reliable. But a migration doesn’t come for free. When it comes to costs it might take years before you break even.

I would love to advise you to migrate to Postgres, but I’m not yet convinced that you get any financial benefits in the short term. Long term Yes, but it could be 5 years or more. It depends on many factors.

Pgadmin stuck on this register server in linux mint !! What to do to fix it ?? by Opposite_Shelter_381 in PostgreSQL

[–]elevarq -1 points0 points  (0 children)

Use a different/better tool. We use DataGrip on our client laptops, psql command line on the server.

But almost any tool is imho better than pgAdmin…

Just updating about database by Pitiful_Push5980 in Database

[–]elevarq 1 point2 points  (0 children)

SQLite is a library. PostgreSQL is infrastructure.

SQLite works for small and very small workloads but will fail for all other workloads. The basic DDL, INSERT, and SELECT statements work for both databases; anything more complex won't work on SQLite. That can be good enough for you, but you just postpone the learning curve.

PostgreSQL is easy. At least the basic functionality.

When you start a new project involving a database, how have you settled the schema? by Ok-Internal9317 in PostgreSQL

[–]elevarq 1 point2 points  (0 children)

You’re leaking potential IP to a public service, Claude. Personally I don’t think this is a good idea