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
帖子
2
评论
196
Joined
2 yr. ago
Emulation @lemmy.ml
Spider89 @lemm.ee

Netplay on 3DS Android emulation?

Hello,

I have noticed that Lime3DS and Citra have netplay for their emulators, however, Android doesn't have a network setting to configure networking.

I do not have another device to test 2 Android phones. I noticed a room is required to use netwoking and is avalible on PC to configure rather than on Android.

Am I missing something? Could I have netplay on 2 Android phones or netplay on a real 3DS?

Programming @programming.dev
Spider89 @lemm.ee

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(