[DiscordArchive] oh you managed to import the whole world db into it easily?
[DiscordArchive] oh you managed to import the whole world db into it easily?
Archived author: vblanco • Posted: 2022-06-23T19:29:03.043000+00:00
Original source
oh you managed to import the whole world db into it easily?
Archived author: vblanco • Posted: 2022-06-23T19:29:04.921000+00:00
Original source
thats pretty great
Archived author: vblanco • Posted: 2022-06-23T19:29:16.091000+00:00
Original source
as thats more or less what i think its the most important to put into sqlite
Archived author: vblanco • Posted: 2022-06-23T19:29:30.269000+00:00
Original source
if one can stuff the world db with npcs/quests/fuckery into sqlite, it should improve the performance of the server
Archived author: vblanco • Posted: 2022-06-23T19:29:43.589000+00:00
Original source
due to lower latency and overheads vs having the db hosted somewhere else
Archived author: tester • Posted: 2022-06-23T19:34:24.173000+00:00
Original source
Understandable
Archived author: tester • Posted: 2022-06-23T19:35:02.278000+00:00
Original source
Why wouldn’t you? You can export the whole thing as a list of insert statements
Archived author: ReynoldsCahoon • Posted: 2022-06-23T19:36:14.057000+00:00
Original source
It wasn't terribly easy, I had to massage some of the table structure definitions, because the ones made for MySQL came with a lot of junk that SQLite doesn't care for.
https://discord.com/channels/40766404101...3590154280
Archived author: vblanco • Posted: 2022-06-23T19:36:52.187000+00:00
Original source
thats awesome
Archived author: ReynoldsCahoon • Posted: 2022-06-23T19:36:53.767000+00:00
Original source
I initially tried to insert it all using the raw import sql from the tc 335 db repo.