Squirrel VS Atlas

It uses Gin as the HTTP framework and PostgreSQL as the database with pgx as the driver and Squirrel as the query builder. It also utilizes Redis as the caching layer with go-redis as the client.

I would add Squirrel to PGX https://github.com/Masterminds/squirrel

I have written about this before, and my thoughts always settle on using a query builder. I've built a simple one, which works for what I need, but there are more feature complete ones out there such as squirrel. I've also written about how you can implement a simple CRUD library for database interactions using generics and query building to have that nice middle-ground between an ORM and query building.

Now for the dynamic queries you have to be really careful to prevent SQL injections, there are bunch of different ways to do it but I typically recommend using a package such as squirrel that lets you do this easily, you use it to generate the plain SQL you need (and then use sqlx, database/sql, pgx or whatever you prefer) or use it directly querying the database directly.

Here are 2 options for you * https://github.com/huandu/go-sqlbuilder * https://github.com/Masterminds/squirrel

https://www.reddit.com/r/golang/comments/vq98ud/what_sql_library_are_you_using/ Jet havn't used but is one that looks promising! Otherwise I'm one of the purests, db/sql and https://github.com/Masterminds/squirrel

I think he means an sql builder like squirrel. This allows dynamic queries, but more important you can reuse function that build a where clause so you can get a count and query with that.

I'd rather suggest the use of tools more aligned with the core concepts of the language such as sqlx, which is an extension of the database/sql standard library. It allows you to use models/structs to map your tables but you have more control over the SQL statements you use to perform queries and the like. You can combine sqlx with Squirrel to build queries from composable parts.

But using a query builder, something like squirrel or (plug) bqb, allows you to actually write SQL (or something close to it) when you need it but also handles the nasty string building bits. Though I agree that ORMs are not always bad, especially for small projects with well-defined scope.

Plug for bqb as a query builder, but there's also squirrel which works pretty well too.

> 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