Programming thread

  • 🔧 Site instability resolved. You can report double-posts and broken attachments. For bigger issues, use the Technical Grievances thread.
    🇵🇦 Nuestro primer dominio localizado está en español en kiwifarms.pa. Our first localized domain is on Spanish on kiwifarms.pa.
  • Want to keep track of this thread?
    Accounts can bookmark posts, watch threads for updates, and jump back to where you stopped reading.
    Create account
1754413222679.webp

I have never tried to watch Theo for content so I have no clue what he's about for hobbies or his actual work. The most I looked into him was with regard to Piratesoftware since they went to the last defcon together, along with ThePrimeagen and some others.
 
Been using SQLite for my Node project and have absolutely no idea what I'm doing. First time I'm using either so a crack at the documentation and a lot more tinkering should get me caught up. Any resources you recommend?
I have my own biases and particular knowledge (don't really like programming webshits) so, with that said, in your position, I would first dive into SQL. SQL is in itself incredibly useful for all kinds of things and the overall relational database concepts you'll learn apply even outside of the SQL context, as with pandas DataFrames. I used the 2nd edition of Learning SQL from O'Reilly quite a few years ago, and there is a 3rd edition, but Practical SQL from No Starch Press (now in its 2nd edition) looks very promising too. Either of these two books will train you on a SQL implementation more fully featured than SQLite, which is pretty stripped down. The former uses MySQL and the latter uses the somewhat heavier PostgreSQL, but as long as you have basic command line knowledge you can set up either without any real difficulty. Also you wouldn't have to read either in its entirety. I would say up to chapter 9 or 10 is adequate for Learning SQL and up to at least chapter 9 in Practical SQL after which you can pick and choose certain topics. (I would definitely learn subqueries, dates and times, and text formatting and matching). Then, when you use SQLite, which has simpler administration and a reduced set of features, it'll be like you're a Roman soldier who trained with a wooden sword heavier than the real thing.
 
Been using SQLite for my Node project and have absolutely no idea what I'm doing. First time I'm using either so a crack at the documentation and a lot more tinkering should get me caught up. Any resources you recommend?
Read The Fine Manual. https://www.sqlite.org/docs.html

SQL is one of those "programming languages" (barely) that will tie your head in knots for a couple years until you learn how to sort things out. It's not something you learn on a lark very well. Sqlite makes it approachable because you can simply copy a file and screw around on your fresh copy and no one gets hurt. And you can do it all from the command line easily.
 
Sqlite makes it approachable because you can simply copy a file and screw around on your fresh copy and no one gets hurt.
That's equally true of the more full-featured SQL implementations and the learning resources for them, or at least based on them, are so much more abundant. At worst you would need a VM or cheap VPS to insulate your main battle station from your experiments.
 
What's a good service to learn Python?
Use the docs and automate some stuff or do some number crunching, whatever it is that has you interested to begin with. The No Starch Press books tend to be more accessible, in my opinion, but they gloss over a lot of the finer details to focus on getting results so it's more engaging. They're also easy to pirate, so try before you buy.
 
incredibly based, c++ is gay
What's a good service to learn Python?
your computer
type python at your terminal (if you don't have a terminal that you can type python at, what are you even doing here? ok, you could use python's idle editor if you want) and start fucking around
eventually make a file called auehfhuiad.py and use it to do whatever
make sure to have the manuals and documentation close at hand as you glue together your scripts
 
Atrás
Top Abajo