 |
Post Ay68tD8QwzsmVsgR1c by [email protected] |
 |
More posts by [email protected] |
|
Post #Ay5mtWYGYu0fk1ViRk by [email protected] |
|
0 likes, 1 repeats |
|
|
|
hey fedi programmer folks, this isn't urgent but i'm going to have to s… |
|
|
|
Post #Ay5nGeOFaK3WiDqxvM by [email protected] |
|
0 likes, 0 repeats |
|
|
|
i mostly ask because databases are for boring stuff and i make games so i have … |
|
|
|
Post #Ay5nGeUHDusP0ufmJk by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko I would not recommend xml (just saying) š |
|
|
|
Post #Ay5nJ00YBJqgKzt6Fk by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@catsalad would you believe i have made this mistake before |
|
|
|
Post #Ay5njGmiQbhntowYLo by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko It's okay, because obviously that was like 20+ years ago, right? ...… |
|
|
|
Post #Ay5nyzJLAAXIL3hMQa by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@catsalad i mean, 12 |
|
|
|
Post #Ay5oH5Ild0ka8C3kJ6 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko Gets unruly after a certain size lol |
|
|
|
Post #Ay5oIIFUyZhQZm6h7o by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@catsalad i also found this >_> |
|
|
|
Post #Ay5pTWtAz91h7XaUHQ by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko you can put the binaries in their own files and have a sqlite for like, … |
|
|
|
Post #Ay5pTWyqe3YzP8F17Y by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@efi i want acid compliance. binary files aren't acid compliant |
|
|
|
Post #Ay5pTjvQW5YDYHjy5o by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko you can have smth like protobuf if you don't think the file structur… |
|
|
|
Post #Ay5pTk3w0SM9yfilM0 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko if i had to do something myself today, and needed it rock solid, i would… |
|
|
|
Post #Ay5pTkBNYmJMLlChxQ by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko bson is pretty niche, but still popular enough it has implementations in… |
|
|
|
Post #Ay5pV32evWSt8AkO6y by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko You may be further along than I realise, but Iād just do whatever is e… |
|
|
|
Post #Ay5pV38gZ7HlQrZCVM by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@bnut i'm just thinking ahead and doing research really |
|
|
|
Post #Ay5pVSxwXg8pX4jzN2 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko I don't have a specific suggestion, there is a lot of good stuff in … |
|
|
|
Post #Ay5pVdqu4C2vIQX1QO by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko files. in directories. |
|
|
|
Post #Ay5pVdwZj6aDa1BYGW by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@drj i do not want to reinvent an acid compliant database made out of files |
|
|
|
Post #Ay5pVe2xLNgftoAeDA by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko haha, yes, i just read your other comment about that :). You were pretty… |
|
|
|
Post #Ay5pVe8yyyVYCUzSbY by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@drj given how much time people sink into block games it's really not accep… |
|
|
|
Post #Ay5pYE1kXXn84OpwXo by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko when talking about databases the first question always should be: is the… |
|
|
|
Post #Ay5pYMcCbthghlxATQ by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko you're being cruel to yourself |
|
|
|
Post #Ay5pYMiEFUWZ0Slyro by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@efi i do not want the responsibility of someone's 100 hour save corrupting… |
|
|
|
Post #Ay5pZ29GBtVZWAjeC0 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko Depends om what type of data. What I know you could either use LevelDB (… |
|
|
|
Post #Ay5pZBUrQx8OVluWbw by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko DB thot. |
|
|
|
Post #Ay5paTS89wU8UTFTSi by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko SQLite? I'm half joking but it seems filling the blanks you have |
|
|
|
Post #Ay5paTYrktsApMOqxc by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Ronflaix if i dont find anything thats a better fit sqlite is my first choice … |
|
|
|
Post #Ay5paTfxKXXnBLiW0m by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko I tried to use it as an asset pack and the IO performance were slightly … |
|
|
|
Post #Ay5pabeTfv7Bv55Rom by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@[email protected] i wouldnt try to re-invent anything here unless y… |
|
|
|
Post #Ay5pablDGsVEFyEpJg by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@privateger i extremely don't wanna reinvent an acid compliant database, tr… |
|
|
|
Post #Ay5pabqsvn2WXYtM9o by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@[email protected] yeah, there be dragons lolsqlite comes with optio… |
|
|
|
Post #Ay5paeXUwKJYsIqPr6 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko make sure to have some versioning in there too, so that you can convert … |
|
|
|
Post #Ay5paqOMs68pdSfII4 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko yeah I thought so sorry, I guess my answer was really āit depends on t… |
|
|
|
Post #Ay5pcBt4RF1AaifUAa by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko binary blobs representing individual chunks, either loose on the filesys… |
|
|
|
Post #Ay5pdaiRbzDBsxMjBY by [email protected] |
|
0 likes, 0 repeats |
|
|
|
people put hundreds, thousands of hours into block game worlds. entire communit… |
|
|
|
Post #Ay5pdaptAJAOG2qfmy by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko I'd go with SQLite until it's proven not to be a good enough fit |
|
|
|
Post #Ay5peQb8iOGYnMLd1E by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko I think the hotness in databases is still NoSQL? but I don't think t… |
|
|
|
Post #Ay5peQiaGiDlARpZce by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@ghosttie zipped xml isn't robust enough. i don't want to risk corrupti… |
|
|
|
Post #Ay5pfTZd8YgGJV8qBs by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@crypticcelery i'm using C# so i guess bindings for that are a requirement |
|
|
|
Post #Ay5pgWzltvDHDOs8Se by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Atridas i dont know, is there |
|
|
|
Post #Ay5pge8XLjNrMc1jay by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko I would guess that that is popular enough in the general case, at least … |
|
|
|
Post #Ay5pmc5TsimqkHRWCW by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko Given that even a Clip Studio image file is an SQLite database, I guess … |
|
|
|
Post #Ay5ppuoCjTm5g3w7EW by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko LMDB is my go-to library for in-application DBs. Fast, simple, flexible … |
|
|
|
Post #Ay5pqvzNpV9NcyeQu8 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko OK then you're going to have to make the data fit into rows/columnsS… |
|
|
|
Post #Ay5qxSgVHVjIirUqsy by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko usually nothttps://www.sqlite.org/whentouse.html |
|
|
|
Post #Ay5qzpqA9xnj7O98qm by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko so how are you gonna store blocks? |
|
|
|
Post #Ay5qzpvposL1Oynfgu by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@efi probably as binary blobs |
|
|
|
Post #Ay5qzq1rST9thfcU5I by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko so which one is it??? |
|
|
|
Post #Ay5qzq7X7NhBzGH0vQ by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@efi you can store binary blobs in a database |
|
|
|
Post #Ay5qzqCqnbwuFklGDI by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko that's what I said and you said "but acid" |
|
|
|
Post #Ay5qzqHoV9v2V95Dwu by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@efi you said binaries in their own files and sql for more traditional stuff? |
|
|
|
Post #Ay5qzqOu4naer8Ot04 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko and then, or blobs in the database |
|
|
|
Post #Ay5r1SmmqY74CALN6u by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@efi ohim pretty sleep deprived so i didnt see that |
|
|
|
Post #Ay5r1StASpDWVxKT3Y by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko *coffee hugs* š¾ |
|
|
|
Post #Ay5sL9ohBQAr6pBume by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@catsalad @eniko Isn't xml the storage format for rimworld saves? |
|
|
|
Post #Ay5vbc1SNkYp5FhLKS by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@rallias @catsalad wait for real |
|
|
|
Post #Ay5veIAOf6LWN39pJI by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Atridas @eniko agreed |
|
|
|
Post #Ay5vfGuYoavKlbDXay by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@rallias @catsalad @eniko Oh I have (very naively) thought that xml was like, t… |
|
|
|
Post #Ay61QNxytwSG1s6PMu by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko Slight tangent, but this has definitely come up with the worlds from my … |
|
|
|
Post #Ay61QO4MWDYiLf5VJY by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@gregly mostly 1st person but i want to add a 3rd person camera mode |
|
|
|
Post #Ay61QOB67AwkgYEsoS by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko Nice! Itās been wonderful following your progress. My early attempts a… |
|
|
|
Post #Ay61agjC09J97367X6 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@rallias @catsalad @eniko I have seen XML as a scripting language |
|
|
|
Post #Ay63DG6V1Tg9msxGzo by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko sqlite is super popular for this sort of thing. It might seem like overk… |
|
|
|
Post #Ay63DGF0VqU6DGw4G0 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko but it sounds like you maybe want less of a database and more of a seria… |
|
|
|
Post #Ay63iN5p5UJeROTTFo by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@catsalad @eniko JSON is absolutely the better solution. |
|
|
|
Post #Ay65NDFsfWrvkyDX8q by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Atridas @rallias @catsalad @eniko every problem can be solved by either adding… |
|
|
|
Post #Ay68lW6UXdu71j6eH2 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko SQLite is almost certainly what you want. Old, slow-moving and reliable … |
|
|
|
Post #Ay68lWCs9v0ZLW5kDg by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@mort i honestly do not trust any filesystem more than an sqlite database >_… |
|
|
|
Post #Ay68tD8QwzsmVsgR1c by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko Oh but this means you'll be working with untrusted sqlite files beca… |
|
|
|
Post #Ay6BUMAKXOsR8zPWa0 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko Bear with my ignorant suggestion, but would HDF5 work in this role? http… |
|
|
|
Post #Ay6DHNCRa7KGUkKtyS by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@arclight I looked at this for a bit but it seems overkill for my needs? |
|
|
|
Post #Ay6LEOLBgLhEnYVzrk by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko surreal or redb come to mind |
|
|
|
Post #Ay6MV5kk909g1gznZg by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@eniko after thinking a bit about it. I would save new chunks by a adress that … |
