Readit News- Create constraints as NOT VALID and later VALIDATE them. This allows you to create them without expensive locks.
- explain (analyze, buffers). I miss this so much.
- Row level security.
- TOAST simplicity for variable text fields. MySQL has so many caveats around row size and what features are allowed and when. Postgres just simplifies it all.
- Rich extension ecosystem. Whether it's full text search or vector data, extensions are pretty simple to use (even in managed environments, a wide range of extensions are available).
Is that (and more) enough for me to migrate a large MySQL to postgres? No. But I would bias towards postgres for new projects.
NVIDIA’s data science and AI platforms, like the RAPIDS open source suite of analytics libraries, power modern data science and engineering across the world. The team builds or integrates dozens of tools, collaborating with both commercial partners and the open source community. We are looking for an outstanding senior engineer to play a key role in packaging, automation, and related infrastructure.
This role is perfect for an enthusiastic generalist who knows or wants to learn technologies ranging from the guts of Python wheels, Conda packages, and CUDA/C++ libraries on up the stack through Docker and Github Actions. You will have the opportunity to contribute to both open source and enterprise platforms trusted by our largest partners. You will be able to improve deployment on next-generation, pre-release NVIDIA hardware and software platforms and contribute back to help major GPU-accelerated packages fit in well with the open source Python ecosystem.
Full job desc is here: https://nvidia.wd5.myworkdayjobs.com/NVIDIAExternalCareerSit...
Note: this post is just covering one opening from our team in particular, but NVIDIA has hundreds of other open roles here: https://nvidia.wd5.myworkdayjobs.com/NVIDIAExternalCareerSit...
Get one client. Do an amazing job. Use that to tell other clients what you do.
Be specific. Most people outside tech have no idea how it works. Tell them what they will get.
Increased sales, reduced costs, better productivity. Whatever it is you do, forget about the tech and talk about the benefits.
Get your elevator pitch right. Mine is "I help businesses fix their procedures". People then say "You know, I could introduce you to my friend...."
Business first, tech last.
Not sortable. Takes a lot of space. Table relationships are annoying. Etc.
What we do instead is have a secondary UUID key and keep Bigint as primary keys. Then use the UUID column in the external context instead.
UUIDs are fine for 99.99999% of the time in your own domain.
Don’t expect universal uniqueness across all domains.
Or whatever you want really. I recently contemplated what I would do if I won the lottery and arrived at that conclusion. Hopefully you arrive at yours.