But they silently converted the string '1' into the number 1. So now in my same code, I want to select back my stringy '1' that I putted in the type affined INTEGER column.
And you are telling me its normal that I don't get it back ? Or maybe I'm misunderstanding something?
Most of the time the fix is: put quotes around your strings (especially when they may contains globing patterns). Sometimes its using newer syntax available in bash but not on the snippet.
I only have to "quotes" strings that contains globs. The rest mostly work or use the newer/recommanded way to do things for posix shells.
But I must admit, I only use it interactively. For scripts I #!/bin/{,ba}sh. I will use something else once it won some/most the distro preinstalls (either nu, elvish, fish, but for now it's sadly python).
Thanks to valve/proton, the biggest issue for playing on linux nowadays is the kernel level anti-cheat they force on some competitive games.
Other than that most of the games just work, especially if they were made in a common engine (godot, unity, ue, …)
The only AAA I play are Nintendo ones (and RTS/MOBA since its a niche genre and you need a community for PvP). Since quite some times already. But I only look out for indies, I love getting new experiences and gameplay.
And even when the gameplay is not new, the attention to details (gameplay wise) is at 1000% only on indies (Celeste, Hollow knight, Factorio, …)
I think some peoples developped an allergy to projects being (re-)written in rust. Not sure why.
I don't know elvish, but I can't get into nu. It is too different than what I learned (bash). I'm not sure I understand what they want to accomplish… Maybe I'm not the target, I use the shell to start commands as a dev, not as a devops or data guy…
I also had a hard time using fish the first time I tried it. But since the version on Debian 10 I re-tried and now the only thing to know is "put the arguments in quotes if you want the command to do globbing". With that you can use 99% of the commands you find on internet as is.
I used Kresus some times ago on a server. It was nice, but my bank don't play nice and it is not my thing to manage like that.
It should auto import and… I did not follow developments so don't remember the functionalities.
I'm on Linux and a prebuit PC would be a nice change. But at the same price or lower than Windaube, since I don't want a licence for them.
I will prefer to build myself rather than paying an extra k…
Did you tried UnCiv ? Feels like garbage to play to me. Maybe it is just too complete for my mobile game sessions... (And I don't really like civilisation turn based games anymore.)
Mindustry (factorio like) plays badly on mobile (everything is too small, touch is not precise need to zoom a lot but you don't see anything/can't build long belt that way). But now I want to play it on PC.
On the other hand, Feudal Tactics is really nice to play on mobile.
Apparently stow -t exist too.
I think one of them should be "strongly", but I understood your point.
Thinking back, I don't have the doc easily accessible (on phone), but I think the C API state the type you want to read. Like
get_int(smt, VALUE_INDEX, …), so at least in the C API, most of this should not be visible. Maybe only theSELECT 1 = '1'part (or others comparaison fully done in the SQL string)?