Atlas VS migrate

> I usually have to spend an hour just removing stuff, disabling things and multiple reboots just to trim things down.

All of that is automated now. https://atlasos.net

How is this not clear?

"A modification of Windows, designed for gamers."

"Performance: By Removing unnecessary components, disabling power-saving features, and optimizing services."

"Privacy: By eliminating Microsoft's notorious tracking, pre-installed apps, and bloatware, you can feel confident when using Atlas."

Github link https://github.com/atlas-os/atlas

As a last hope you could backup your windows install and try installing Atlas OS on top, haven't tried it yet on Win11 but it should clear some process and ram for the game to run : https://atlasos.net/ MAKE SURE YOU BACKUP YOUR WINDOWS DISK FIRST. I'd recommand a software that you can launch on a USB stick instead of a program ran from Windows. I used https://www.easeus.com/backup-software/ but many others offer backups and PE USb bootable ISOs

Ok the whole story. My LLG started BSOD after doing a system restore because of a borked Handheld Companion install. So instead of using the recovery image I thought "now would be the perfect time to try out a vanilla Win 11 install and use AtlasOS” to see the difference it makes when it comes to gaming. So I download the drivers and Legion Space from Lenovo, Win 11 ISO, and AtlasOS files and I do think that it gave this beast some claws. It seems twice as fast as before without useless processes running in the background to bog things down. All the useless bloatware is gone and my LLG is running like a well oiled machine. I will run test later to compare but I think I have a winner here.

You can't, Windows >7 is a pain to have on a hard drive and will use 100% of it all the time. If you don't want to get an SSD, your best option is atlasos.net which isn't as good than getting an ssd but better than stock Windows.

AtlasOS turns Windows into a pure gaming OS. It removes all bloatware and system hog.

One modification that had a suprising effect was installing AtlasOS on top of Windows 11 using the AME wizard and Atlas playbook. https://atlasos.net/ - this produced an immediate and noticeable responsiveness improvement across the board. Before AtlasOS the mouse was still too slow even at the fastest setting in Windows. After AtlasOS everything was so much more responsive I had to slow down the mouse slightly because it was now moving so quickly and smoothly. I'm still a little dumbfounded by how good AtlasOS actually seems to be. But it's yet to be seen if whatever was gutted from Windows will cause issues down the line.

Apparently this one is optimized specifically for "AAA game" players and is frequently updated. I'm installing it now https://atlasos.net

Go does not natively support the use of migrations, but we could use the ORM that has this functionality, such as GORM which is the most used by the community, but We can use migrations without using an ORM, for this we will use the golang-migrate package.

$ curl -L https://github.com/golang-migrate/migrate/releases/download/$version/migrate.$os-$arch.tar.gz | tar xvz

Golang-migrate is a database migration tool designed for Go applications. It helps manage and apply changes to the database schema as the application grows, ensuring that the code and database structure stay in sync.

First of all, thank you for SQLAlchemy! If I ever had to make a final choice in how I would interact with a database for a very large project that involves a considerable dev team, I would always bet on SQLAlchemy. Not that I would necessarily like all aspects of it, but when it comes to Python and SQL - “Nobody ever got fired for picking SQLAlchemy.”.

With that out of the way, despite ORMs doing much more than "just writing SQL", it is exactly on that point that I flinch: Most devs should be exposed to SQL. And if your project allows you to build around simple enough abstractions so that you aren't reinventing the wheel, you should definitely be writing SQL. Especially if you don't know SQL yet - which is the growing case of new devs coming into the job market.

You can achieve a lot with SQlAlchemy Core, a tool that I absolutely recommend, but my post is just a simple alternative to get developers to think about their approach. If that results in some devs reconsidering using "full fat" SQLAlchemy and to try SQLAlchemy Core, that's a win for me!

Your gist tries to highlight the difficulty of doing certain things without an ORM. Migrations (as just 1 example) doesn't need to be hard, simple tools like flyway, or migrate (https://github.com/golang-migrate/migrate) achieve a similar result (while also keeping you on the path of writing SQL!). Deep and complex relationships between objects also don't need to be hard - typically people approach this subject with a requirement to be very flexible in the way they want to build queries and objects, but that to me in a sign that maybe they should reconsider their business logic AND reconsider that, just maybe, their project doesn't require all that flexibility, it is fairly straightforward to extend objects and introduce some more complex representations as and when it is needed - will all of this make me write code faster? Absolutely not. That is why you have spent so much time perfecting SQLAlchemy, but then again, I am not advocating for devs to go and replace their usage of ORMs, just presenting an alternative that may or may not fit their needs for a new project + give devs the chance to learn something that the ORM might have taken away.

Doing this now with a mysql db for my use case. Using sp to take a large chunk of data migration load off my data layer code. I am using migrate (go library) for migrations and hooked it up with a bunch of test suites for all SP and Triggers it creates. I test it against a testDB maintained as part of my CI/CD. Haven’t had an issue with production yet. It does however require quite a bit of initial setup.

Before we can start using MySQL we need to create a table to store our data. I will be using excellent migrate database migrations tool, it can also be imported as a libraray.

We need a database table to store our application's users' data. To generate and migrate a schema, we'll use golang migrate. Kindly follow these instructions to install it on your Operating system. To create a pair of migration files (up and down) for our user table, issue the following command in your terminal and at the root of your project: