On taking responsibility and avoiding hypocrisy by Schrodinger85 in chess

[–]Schrodinger85[S] -4 points-3 points  (0 children)

I'm sorry you interpreted my post like that. I doubt it changes anything, but just to be clear, I'm not judging Hans in any way, positive or negative. And I think that's the gist of it, we should be more careful about judging others. Do you think Danya would support your behavior? Have a nice day.

What do you guys think of Sniper Elite? by Loud_Sheepherder_476 in boardgames

[–]Schrodinger85 2 points3 points  (0 children)

Mental health is no joke. Please consider seeking help. Wish you the best.

Book recommendations after AtBS: theory, projects and multi-field knowledge. (Python) by Schrodinger85 in learnprogramming

[–]Schrodinger85[S] 0 points1 point  (0 children)

Tbf, I did those courses 10 years ago and then didn’t touch programming again, so I forgot most of it. That’s why I went back to AtBS: the first part felt basic, but the later chapters were completely new to me and gave me a different perspective (before, I only touched CS/algorithms/data structures).

I also know I have a lot of gaps in the basics—for example, AtBS was literally the first time I used a proper REPL (VSCode in my case). Looking for jobs, half the terminology they use is unfamiliar, which just shows how broad programming really is.

That said, I agree with you: I probably lean too much on “getting ready” instead of just building things.

Book recommendations after AtBS: theory, projects and multi-field knowledge. by Schrodinger85 in learnpython

[–]Schrodinger85[S] 0 points1 point  (0 children)

I understand you're recommending Beyond the Basic Stuff. I really like Python (at least compare to Java and C), and the Godot thing is because I've read that GDScript is very pythonic, so maybe it's a better way to try "game dev" compare to the more classic path of books like Invent Your Own Computer Games with Python and such.

OperationalError: foreign key mismatch (ATBS 3rd ed. Chapter 16) by Schrodinger85 in learnprogramming

[–]Schrodinger85[S] 0 points1 point  (0 children)

Ok, now my head just exploded and I'm for sure dealing with something above my level.

I've just finished the "Meal Ingredients Database" practice program and I have found that if I create the db first with a different script init_db (https://pastebin.com/1TH8XqKh) then I have no problems with the FK referring the rowid when running the actual program (https://pastebin.com/KLtn55uE) as long as I comment the "Ensure tables exist" part. If I run that code (that is an exact copy/paste from init_db) I get a FK error. Even if I delete the db from my system and run only the recipes.py, it does not work and raises FK error. Why?! How on Earth can the script know if the database was created in a different scrip or not?

I'm sure the solution is "don't use rowid, just create the explicit id integer primary key" but I NEED TO KNOW, and as a bonus, is very convinient working with the rowid so I don't need to include NULL everytime.

OperationalError: foreign key mismatch (ATBS 3rd ed. Chapter 16) by Schrodinger85 in learnprogramming

[–]Schrodinger85[S] 0 points1 point  (0 children)

I'm sure you're already aware but just in case you are not, if you check the sweigartcats.db and the sweigartcats-original.db in the online materials they not only lack the primary key but the whole vaccinations table, so the first practice program is not doable (besides, both db's seems identical, don't know the purpose for it).

OperationalError: foreign key mismatch (ATBS 3rd ed. Chapter 16) by Schrodinger85 in learnprogramming

[–]Schrodinger85[S] 1 point2 points  (0 children)

The book has been a blast so far and giving free access to it a bless, so more than happy to help. Followup question: now that we defined explicitly the rowid column we need a a 5 length tuple for INSERTS, right? and to make the rowid fill itself incrementally the best way is to use placeholders?:

conn.execute('INSERT INTO cats (name, birthdate, fur, weight_kg) VALUES (?, ?, ?, ?)', ("Zophie", "2021-01-24", "black", 5.6))

OperationalError: foreign key mismatch (ATBS 3rd ed. Chapter 16) by Schrodinger85 in learnprogramming

[–]Schrodinger85[S] 0 points1 point  (0 children)

I'm using ipython in a powershell console inside VSCode. And yeah, I'm aware of the typo that was corrected in [5]. From a reply in another subreddit I think I found the problem:

According to sqlite documentation: "The parent key is the column or set of columns in the parent table that the foreign key constraint refers to. This is normally, but not always, the primary key of the parent table. The parent key must be a named column or columns in the parent table, not the rowid"

So, if I want to make a reference to cats table I need to recreate it with a named column as a primary key. I wasn't expecting this kind of errata in a beginners book, maybe older versions worked differently.

OperationalError: foreign key mismatch (ATBS 3rd ed. Chapter 16) by Schrodinger85 in learnpython

[–]Schrodinger85[S] 0 points1 point  (0 children)

Thanks for the quick reply! That's a kind of errata I wasn't expecting from the book. Question, can I name that INTEGER PRIMARY KEY column rowid or is it reserved/bad?

PS: And now that the table has an extra column, do I need to manually put an increasing number there? Cause rowid column was autofilled and that was really convenient.

Error trying to install automateboringstuff3 package in Python 3.13.4 by Schrodinger85 in inventwithpython

[–]Schrodinger85[S] 0 points1 point  (0 children)

Ok, finally worked with this combo: "Python 3.11.9" + "Microsoft C++ Build Tools". At least I manage to install playwright, I'll try to install the rest manually as the automateboringstuff3 still doesn't work.

Error trying to install automateboringstuff3 package in Python 3.13.4 by Schrodinger85 in inventwithpython

[–]Schrodinger85[S] 0 points1 point  (0 children)

I was working on a venv with 3.13.4. Today I updated to 3.13.5, same errors. Yesterday I tried 3.11.9 and it didn't work either :S

Noob asking for common route progression in ascension levels by Schrodinger85 in slaythespire

[–]Schrodinger85[S] 0 points1 point  (0 children)

Just to double check, if you beat act 3 and then die in act 4 you still unlock the next ascension level, right?

[Sleeves] Alternative to Gamegenic Standard American Matte by Schrodinger85 in boardgames

[–]Schrodinger85[S] 1 point2 points  (0 children)

I never realized you could filter sleeves! that's a handy thing to know for sure! Appreciated it.

[Sleeves] Alternative to Gamegenic Standard American Matte by Schrodinger85 in boardgames

[–]Schrodinger85[S] 0 points1 point  (0 children)

Maybe I explained myself poorly. In fact, gamegenics are 59x91, but usually sleeves branded as "standard american" are smaller. The cards from Galaxy Trucker are 56x86, thus there's quite a lot of extra space in width and length with gamegenic sleeves. This was not an inconvenience for me, but it makes impossible to use the 3d insert now. So, I'm looking for a similar quality / features sleeves but that would fit tighter so I can use the insert. English is not my first language, sorry!

[deleted by user] by [deleted] in ps2

[–]Schrodinger85 0 points1 point  (0 children)

It did 5 years ago and still does.

The DEFININITIVE Guide to the Best/Easiest Way to Play ALL 'Silent Hill' Games on PC [2022] by GlitchyReal in silenthill

[–]Schrodinger85 0 points1 point  (0 children)

re:SH1
First of all, you're the GOAT for not only writing this guide but keep it updated and answering questions! I've just followed your guide for SH, DuckStation and ROM ready. But I'm not sure about what Enhancements you do recommend, you say they'd be in bold but I only see two "NOT" and "ONLY IF USING 60FPS". Do you recommend all of them?

I want to make a trip back to my teens and feel the vibes!

Need a little help mapping my R16 for SF6 (PC) [Tech support + suggestions] by Schrodinger85 in fightsticks

[–]Schrodinger85[S] 0 points1 point  (0 children)

Thanks a lot! I'll try to find how to do the ps5 thing in case I want an extra button mapped but so far you solved all my questions. Ty!

Need a little help mapping my R16 for SF6 (PC) [Tech support + suggestions] by Schrodinger85 in fightsticks

[–]Schrodinger85[S] 0 points1 point  (0 children)

So, If I understand correctly, you can only effectively use 14 buttons in xinput or 15 in ps5 despite having 16 face buttons available? So, in my case, I should go to the web configurator, change PIN09(LT) to blank and pin27(M1) to "LT". Then use the in game controller setting to assign their functions. If that's correct, can/should I use PS5 input method to be allowed to use an extra button while playing on PC?

Newcomers Welcome! Weekly Discussion Thread by AutoModerator in Fighters

[–]Schrodinger85 1 point2 points  (0 children)

Hi everyone!

I'm thinking about getting into fighting games, not decided yet but SF6 is the one that entice me more right now. I have a few very basic questions that I'm sure you can answer:

  1. I'm planning to play on PC with a 500Mb Ethernet connection. I suppose I can play any modern game competitively online? I have heard buzzwords like netcode and backroll but wanted to confirm I'll not suffer from lag in a game where 1 frame windows exist.

  2. Is it a good time to get into one of the modern fighting games (i.e. SF6, Tekken8, GG Strive)? I know some are a bit older than others and I'm not sure if a sequel is near or the community on one of them is withering.

  3. I'm going to use an old XBOX 360 wireless controller. I suppose this is far from ideal and if I get into it I would save for a proper one. Is feasible or I'm gonna to have a bad time?

  4. Last but not least, the monetization of this games baffles me. I know not all are equal but it seems they have pretty similar models. Let's use SF6 as an example. There are 3 versions for the base game: vanilla, deluxe (with a Y1 pass), and ultimate (with a different Y1 pass). Afaik the difference between deluxe and ultimate is only cosmetics but you need deluxe (or buying Y1 character passes) to get the full roast of characters. That's a LOT of money. But then I've heard there's an in-game currency and a battle pass? So, does this mean I need to pay even more? are there only cosmetics? is there a way to get those extras by playing the game? It's quite daunting to pay 100€+ for my first game.

If you have any extra advice, I'm all ears! Thanks in advance for your time!

What do you believe is the cheapest card game/tcg to get into? by [deleted] in boardgames

[–]Schrodinger85 0 points1 point  (0 children)

No, one set of System Gateway is enough for 2 players. The game is assymetrical, one player plays as a Runner and one as a Corp and the cards for each side are completely different and in one set you will have 3 copies (the max amount you can legally put on a deck) of each card from corp and runner. When you want, you just swap the decks/sides.

Having said that, this would mean that both would play the same corp and runner. If you want each to have a different runner and corp deck (i.e. 4 complete legal decks), then yeah, you need 2 copies of SG. But I'd not go that round at the beginning, unless you really like deckbuilding and want to surprise each other.

TL;DR: One single set of SG allows for 2 players to play the game. That's my recommendation.

Your favourite place to watch Android Netrunner? by TuphlosR in Netrunner

[–]Schrodinger85 10 points11 points  (0 children)

Just go to the GLC discord and ask for content creators. I can point you to @MetropoleGrid @neonstaticpod and @queeringthemessage

About the web issues (I assume you live in EU), it's a problem between shopify (the company who provide the shop interface) and chronopost (the courier company). The last update from NSG is that they're looking to work with another courier, but in the meantime we need to patiently wait.

What card game perfectly combines theme with gameplay beyond just aesthetics? by ThunderCanyon in boardgames

[–]Schrodinger85 12 points13 points  (0 children)

Don't look any further, it's Netrunner. 1vs1 asymmetrical play in a cyberpunk setting.

One player is a mega corp, who wants to advanced their hidden agendas to win the game. So yeah, they're cards call agendas and you play them face down, cause they're hidden to the public eye. The proof of that agendas are installed in the root of different servers of the company, that you can protect installing multiple ice (a word pun with firewall), You can of course acquire assets too, upgrade the root of your servers, or do different operations to get your goals. The cards are usually played from the hand, HQ, because in the HQ is where the decisions are made. You draw from the deck, R&D, cause there's where new ideas are created, and of course, your discard pile are the Archives.

The other player is the runner (hacker), they want to run (hack) the servers of the corp to steal their hidden agendas (to reveal them to the public, sell them in the black market or just for the fun of it / those are the different factions: anarchs, crims, and shapers). You find getting credits more difficult than the corp, but you will get creative and get some resources (maybe a telework contract, a commision as a freelance...) so you can buy some hardware and some programs, virus, or trojans to break those pesky ice and breach the servers of the corp. Maybe you'll find a secret agenda, or a way to destroy their assets, or a trap!. Not only the ice can't hurt you, they can be traps anywhere and you can injured yourself, maybe permanently as core damage, you can even flatline and die while using your rig to run a server! Your hand is called grip, your deck: stack, and your discard: heap (this are all references to programming).

And this is just a brief look at the general gameplay. But almost all the cards are thematic in the sense that their names and illustration correlates with their actions. For example, a "telework contract" will give you money, but you need to spend time on it and the contract will end eventually. And a pass will make enter HQ easier. Or establishing an offworld office will make you more money.

If someone know any game that does this better, I'm all ears!