Skip Navigation
InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)SP
Spider89 @ Spider89 @lemm.ee
Posts
1
Comments
144
Joined
2 yr. ago

Mastodon Myths

  • nano/Kate >>>

    • Me after installing Bazzite

  • I wanted Debian over Bazzite.

    I'm not a fan of Bazzite.

    • i like pokeballs.

    • Me after installing Bazzite

  • I have Debian on my Legion Go because of this.

    • Choose a number, 1-5!

  • 1, 4

    • Asking the hard questions

    • Asking the hard questions

  • Too much PNG.

    Needs more JPEG.

    • Trump Announces Seal Team 6 Killed U.S. Protester in Daring Overnight Raid (The Onion) - YouTube

  • I was never closest to eating the onion till now.

    • Notepad

  • I prefer Kate. (Da best)

    (It's also Windows supported.)

    • What was your first Linux distribution?

  • Ubuntu > Mint > Manjaro > Arch > PopOS > Debian

    (History, not ranking [Debian wins])

    • Better not be a simp to Microsoft

  • FreeCAD has a... different workflow.. than other CAD's. It's confusing at first, but once learned, it's pretty easy to use.

    I have used FreeCAD in place of Fusion360 for school and I found it better. Of course, not everyone will have basic operations and a different tool has a new learning curve.

    Keep in mind that FreeCAD is also in development. No company (that I know) backs the development, making an open-source versatile CAD software takes a lot of time and has a lot of bugs/limitations.

    I know I shouldn't say this, but hopefully all tools (even non-free) will be available under Linux.

    • It's time guys

    • It scares a grown man

  • GNOME Disks

    • Better not be a simp to Microsoft

  • There's FreeCAD.

    • The Galaxy A56 is the worst mid-range phone I used in 2025

  • How about a Sony Xperia phone?

    • Why do you use the distro you use?

  • I like apt and is great stability for servers and unstable branch for desktops/laptops/Legion GO. (Debian with Xanmod).

    • There’s AI Inside Windows Paint and Notepad Now

  • Kate is also available on Windows.

    • This is why we have a defense budget

  • Get out...

    • Do you use your blinker in a car?

  • Do I still count even if I have an ultrawide mini mirror?

    • Steam does what Nintendoes and Nintendon't

  • Where?

    • Programming @programming.dev
    Spider89 @lemm.ee
    HELP/~Solved~

    Converting JSON to Sqlite in C

    I am trying to create a program that downloads a JSON file and I'm trying to convert it to sqlite.

    Why?:

    • I believe the training data on Deepdanbooru is weak compaired to Rule34 or Gelbooru. I have tried compiling the C# for linux, but I decided it was too hard.

    I am a mainly a Web developer who uses basic JS/HTML/CSS. These don't help as I need it to be in C. (Not ++/#). I have tried using AI to assist, but no matter what language I use (Python, Ruby, Java, C), It will fail.

    Here is the closest I gotten ( 〔〕 --> ><: 

     undefined
        
#include 〔stdio.h〕
#include 〔stdlib.h〕
#include 〔string.h〕
#include 〔curl/curl.h〕
#include "cJSON.h"
#include "sqlite3.h"

#define URL "https://danbooru.donmai.us/posts.json?page=1&limit=1000&tags=duck&json=1"

#define DB_NAME "data.db"

static int callback(void *NotUsed, int argc, char **argv, char **azColName) {
    int i;
    for (i = 0; i < argc; i++) {
        printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
    }
    printf(