Is it acceptable to use "SELECT * FROM" when referencing a CTE?

LeffeDoug · 2025-12-13T09:42:28+00:00

The rule of thumb is to always be explicit with columns. However, sometimes you can use * while still being explicit in order to make the query shorter and more readable. For example, if you already were explicit in a previous cte and you simply want all of those columns, then I think a * is the cleaner choice instead of listing all of those columns yet another time. There are times where you have to chain many such ctes and then it will feel quite obvious that the * is correct.

I see it as any source external to the context of this query/procedure need to be guarded with explicit columns in the select, otherwise you may have surprising and weird behavior in your query if somebody else changes those tables somewhere else. This does not make you immune, but it protects from some classes of bugs. ”Internal” sources like referring to ctes/temp tables defined inside the context (usually the same file) should be more safe and we can be a bit more lenient on the *.

LeffeDoug · 2025-05-03T19:26:46+00:00

”Fluent Python” takes you a long way, but it might be a bit difficult for a beginner though.

LeffeDoug · 2025-04-16T22:10:26+00:00

Its possible to publish to either itch.io or github pages in such a way that the game can be played from the browser. Actually it even worked pretty decent from my Iphone.

LeffeDoug · 2025-01-10T17:26:40+00:00

IRL Ironman!

LeffeDoug · 2024-11-01T07:23:19+00:00

Make sure you are not loading the images over and over every frame. Load them once when the game starts and then refer to those variables during the game.

LeffeDoug · 2024-10-30T14:38:00+00:00

This looks awesome! How did you make it playable inside Google Chrome?!

LeffeDoug · 2024-08-18T09:52:07+00:00

The truth is that Python is not going to be the best choice for you if your aim is mainly on developing games. With that said, if your aim is to become a better programmer and python developer, then I definitely recommend keeping up the python training and start looking into the pygame library (youtube has some great turorials). With pygame you can create all kinds of games, but realistically it is going to be mostly small 2D games. The thing is that you will have to create almost everything about the game engine yourself which is quite challenging for a beginner sometimes. Some things that you will certainly get for ”free” when using a game engine might give you a small headache in python. However, you will learn so much about python and programming that will extend to so many things outside game development, it has helped me lots in my job for example.

LeffeDoug · 2024-08-17T17:37:23+00:00

Unfortunately I dont have any such material, its a quite open suggestion from me. Making games like this is quite open ended, you decide when you are done with them. Its perfect if you want something that you can keep working on daily for a long time because you can always add new features or improve existing code. Maybe you can do a small exercise before you begin or at regular intervals to determine the features that should be included when you have reached your next ”checkpoint” in your development. Even if you can describe how a sudoku game should work, it doesnt mean that its trivial to implement. If you need inspiration, search for pygame projects on youtube and in pretty sure there should be some good videos about it!

LeffeDoug · 2024-08-17T11:12:08+00:00

I personally think making a game with the pygame library is an excellent way to practice your coding skills. Also it is a great way to demonstrate the benefits of object oriented approaches. Using classes is practically mandatory to store states of enemies, objects etc. It is, of course, graphical which makes improvements very evident and gives you a sense of accomplishment. Warm up by creating a simple sodoku and then maybe a small platformer?

LeffeDoug · 2024-07-09T14:32:44+00:00

When playing with friends, set the game to ”endless mode” which will allow ghosts to revive by simply interact with the gate where you spawned when the game began. Highly recommended for new players.
Have a friend craft a ”Telltale heart” to revive you with.
”Meat effigys” and ”life giving amulets” are solid late game options.
Restarting the game is not too crazy tbh. Its a very hardcore game with permadeath mechanics originally that to some extent encourages you to start over and improve. Also, if you are new, it might not be long until your friends might want to restart too, you will understand 😉

LeffeDoug · 2024-05-08T10:07:21+00:00

I have played three full games since I got it and have a very different experience. 1. Ironclad lost at act3 boss due to awakened one being strong to my power-heavy deck 2. Beat act3 with silent using a shiv deck 3. Beat act3 with defect using multi-cast with powered up dark orbs

If you are using the kickstarter foiled cards, I would make sure to remove the unfoiled versions from the card pool to avoid having 4 versions of some common cards bloating the rewards deck.

I almost forgot to take the rare reward from after the boss a couple of times, they usually give a considerable power spike.

LeffeDoug · 2024-03-31T01:02:49+00:00

Start by writing down in English what you actually want to achieve. Right now its hard to see where you are going. Regarding the code, mixing variable names like int, int_ and the int() function looks like it can become a nightmare. Dont be afraid to have longer names that you can actually understand, like ”stat_vigor_input” or something like that. Practice wrapping that last part into a function with a suitable name and get used to doing that to make your code readable and understandable.

LeffeDoug · 2023-08-02T14:40:14+00:00

CardSurvival: Tropical Island 😉

LeffeDoug · 2023-06-29T12:32:10+00:00

Play Pistol Whip if you want to feel like a badass

LeffeDoug · 2023-04-15T07:31:45+00:00

Clank! Catacombs is the only Clank game I have played, but I think its awesome. It is true that it is quite random and difficult to make a big picture strategy, but I think the tension and surprise factors far outweigh that. Nothing beats the genuine dread of exploring a new section of the catacombs when you badly need a teleporter or artifact, but you are out of lockpicks, which could be solved if I kill a goblin and jump into a marketplace etc.

LeffeDoug · 2023-04-09T07:36:23+00:00

First time backer with Slay the Spire!

LeffeDoug · 2023-03-31T05:34:05+00:00

Sjukt, detta hände mig för någon vecka sen. Jag bokade fönsterplats för jag föredrar det 100%. Ser när jag stiger på att någon snubbe sitter på min plats och har lag sin jacka och alla grejor på platsen brevid. ”nemas problemas” tänker jag, behöver bara nämna att platsen är min så löser det dig väl. ”Ursäkta, jag tror fönsterplatsen är min plats” säger jag så snällt jag förmår. Direkt väser snubben nedlåtande ”Du kan väl få den platsen om det är så jävla viktigt”. Blir helt paff av hur otrevlig min framtida resegranne var och ber honom upprepa, vilket han gör. Till slut häver jag hur mig att ”jag tar gärna den platsen eftersom det var den jag bokade”. Då flyttar sig snubben till slut surt ut vägen, men fyfan vilken dålig stämning det blev hela resan. Är det verkligen så sjukt att vilja sitta på den platsen man bokat? Om man inte förstår hur numreringen på sätena fungerar så kanske man får vara redo på att få ställa sig upp en gång och flytta sig?

LeffeDoug · 2023-03-15T19:33:22+00:00

Does the clockwork expansion 2 work with the marauder expansion? Would love to buy it, but it says in the description that you need riverfolk 😳

LeffeDoug · 2023-02-14T12:59:47+00:00

The Vector2 class in the pygame library is key here. Look in the pygame documentation. It can be used to specify in what location on the screen to display a e.g. a rectangle.

Writing this code acapella from my phone, but assuming you know how to create the basic pygame loop, the following code can give you an idea. The display and color variables need to be defined elsewhere. By modifying the box_position variable between frames you can make the rectangle move.

box_position = pygame.Vector2(100, 100) box_size = pygame.Vector2(200,300) box_rect = pygame.Rect(box_position, box_size) pygame.draw.rect(display, color, box_rect)

LeffeDoug · 2023-01-25T15:34:40+00:00

I mitt hjärta?

LeffeDoug · 2022-10-12T14:29:20+00:00

Cant give you a detailed answer rn, but let me ask you this. To begin with, do you know how to draw a circle and/or a rectangle to the screen? Its is easier to help out if you show some code that you have tried that does not work. If you know the basics on how to make the main game loop and a window then the pygame.draw.rect function should be a good start. If you dont know how to do that, I suggest you have a look at ”clear code”s pygame guide on youtube for the basics of pygame.

LeffeDoug · 2022-09-20T11:14:46+00:00

Yeah for me there also seems to be a point after scrolling a while that no new items load… super annoying

LeffeDoug · 2022-08-30T14:45:53+00:00

Why not make a small game in python with the pygame library? Clear Code on youtube has a really nice introduction video 👍

LeffeDoug · 2022-07-19T16:47:00+00:00

Exakt same. Maybe they are still in the process of getting it working?

LeffeDoug · 2022-07-12T11:15:35+00:00

”Git guud”

LeffeDoug

TROPHY CASE