• 2 Posts
  • 182 Comments
Joined 2 years ago
cake
Cake day: June 22nd, 2024

help-circle


  • In 25 Jahren wird den verhätschelten Bälgern im Untergrundbunker dann erzählt, wie Opa damals bei 45 ⁰C nachts mit dem Dieselpanzer zur Tankstelle fahren musste, ohne Klimaanlage, und der Verkaufsraum war auch nicht vernünftig klimatisiert, so dass das Dosenbier nur warm und Grillfleisch viel zu teuer war. Verdammte Grüne damals, da kann unser glorreicher Führer heute auch nix mehr retten!!1!

    Und jetzt raus aus’m Kühlschrank, Oppa is’ warm!







  • I would double down on sqlite for your case. If you are using python, the sqlite3 module is included, but looking at your pseudocode you are probably looking for Godot-SQLite instead. I have no idea what the #python line is supposed to be doing in the first line of your code snippet, besides confusing me.

    SQL is old, and it shows. “Proper” relational database design is a black art, as is optimizing SQL queries, but speaking from my own early experience, you’ll be doing 95% with INSERT, SELECT, UPDATE, DELETE, anyway, with an occasional simple JOIN. This is absolutely manageable and somewhat worth learning, as you’re basically custom building your own data structure according to how you plan to use it most easily. This SQL with sqlite tutorial seems solid to me.

    Beware LLM output. Wild guess is you’ll be sent off on a tangent to normalize your schema, unconditionally use synthetic, unique integer IDs everywhere, and other “best practices” that may not be necessary, and only complicate your structure beyond the point of understanding. Then it’ll be hell to use. Solid groundwork goes a long way, and you can always change things up when you realize “Damn, I’d love to have <some value> in that tuple for a really simple query!”

    Give it a try. Creating your own data structures in the way you want can be really rewarding in itself.

    If you’re gravitating towards a NoSQL database to avoid SQL, you’re basically using dicts again, and will have to learn a different query language, anyway. This may be a more approachable option for you IF your data structure isn’t very nested and uses few complex types, like arrays.

    And yes, you absolutely will find dozens of things to slap into a DB once you got a taste of it, and there’s little reason not to. Save your settings in there, debug info, events… everything can be a table if you’re brave enough. :)





  • I’ll try to add “hw:” in front of the device handles.

    Generally that’d be required if you’re using the hw:<card>[,device] device addressing, yes. You probably want to treat all device names, addresses, and handles as “opaque”, though, meaning you don’t care what the actual string looks like, and select your intended device through some other criteria.

    That’s where default comes from, in a way. It leaves the device choice to the user. I understood that you intend to access some other audio device, typically non-default. In that case it’s ideal if you have any uniquely identifiable device information associated with the class of device you want to use, enumerate all “sound cards” to find those matching your criteria, and “hand down” the associated PCM handle to where you need it, without needing to know what it actually looks like.

    Another way is to get a list of all “sound cards” of the system, and offer a legible selection of names/descriptions to the user in your application’s options to explicitly select the correct device, and have an internal mapping of that selection to it’s ASCII identifiers of PCM handles. Again, no need to know what the identifier looks like, you only need to match the user’s selection to it’s internal ID. This offloads the potentially difficult decision what device to use to your user, though, who may be even more lost being asked that question.






  • Gyroplast@pawb.socialtoich_iel@feddit.orgIch🎭iel
    link
    fedilink
    Deutsch
    arrow-up
    5
    ·
    5 months ago

    Sehr geehrter Oberster Nudelgerichtshof,

    mit Bedauern nehme ich die Ablehnung des Antrags zur Kenntnis, und werde mich fürderhin form- wie fristgerecht beim nächstem Stammtisch über den endgültigen Verfall deutschen Brauchtums, korrupte und inkompetente Behörden und Politiker, sowie die anhaltende Respektlosigkeit der Jugend gegenüber dem Alter beschweren. Vorbehaltlich stelle ich ebenfalls eine fundierte Kritik der Spielweise der deutschen Fußballnationalmannschaft in Aussicht.

    Mit der Ihnen zustehenden Hochachtung,

    Ein Wutbürger



  • Gyroplast@pawb.socialtoich_iel@feddit.orgIch🎭iel
    link
    fedilink
    Deutsch
    arrow-up
    4
    ·
    5 months ago

    Sehr geehrte @instantnudel@feddit.org,

    ich bringe hiermit einen möglichen Verstoß gegen IIeL #1, #5, und #9 zur Anzeige und stelle Strafantrag. Öffentliches Interesse ist bekundet. Ich fordere unverzügliche und kompromisslose Anwendung der Regularien zur Aufrechterhaltung der öffentlichen Ordnung, bevor Schlimmeres geschieht!

    Hochachtungsvoll,

    ein besorgter Bürger

    PS: Ironie ist irgendwann nicht mehr als solche eindeutig erkennbar. Darum hier: ;-)