databases

[frank plover]

i have like never interacted with databases before and i know it is a touchy subject and many people here have many very radical and fiery opinions and preferences and thats why im afraid to even ask. i'd rather save everything to json files than touch sql queries but i decided i need to move on and be a bigger better person. i'd still start with just something easy and do something without tables and joins. let's say points between two players in a game, few matches per day, over a few days. ai recommended mongo for nosql, i thought great must be light weight then, unlike postgres which was like 600mb but no mongo is also 800mb if im even downloading the right thing because it is pushing me to sign up for atlas or what, with a paid freaking plan and azure or aws deployment but god freaking damn it leave me alone i just need like 2-3 entries locally on my server machine self hosted while ai is already constructing for me a whole ass firebase app with esoteric frameworks ive never heard off (js btw, but couldnt not put the python tag to this post). so like what should i use am i even on the right track with starting this simple thing, because im tempted to once again go back to saving stupid json files

[light finch]

I whould suggest with json like data use MongoDB, but you don't need atlas you can host it on your own on docker/vm , no need to pay then. And if you are working with json store the json data directly in DB, don't store it as files (bit me in the arse more than once)

[frank plover]

why is it so gargantuan big

[light finch]

https://www.mongodb.com/resources/products/compatibilities/docker

[light finch]

It can , believe container is smaller , is size a concern ?

[frank plover]

ive recently removed docker from my laptop i did not see an usecase for it for myself

and my server has like 8gigs right now

[light finch]

Ram ? Space ? Vram?

[light finch]

Oof

[frank plover]

ah storage

[light finch]

It's 440.86mb on my image list

[light finch]

Then don't use Windows

[frank plover]

more hassle to migrate right now at 1am than i am willing to give, i am running game servers

[light finch]

#proxmox go brrrr but please tell me your laptop is not the server

[frank plover]

i always assumed its not that big of a deal to read like 1-2 entries but turns out it needs a whole gigabyte of a program

oh its not, its an old as fuck slow as molasses laptop i used lol

[light finch]

Hmm interesting

[light finch]

So it's not on windows then ?

[frank plover]

like, you know, i could just with open("myfile.json") as f: and be on my merry way i just had not thought dbs need such an overhead of a program, rivaling the sizes of some apps .

[frank plover]

it is. ive been meaning to migrate but its still a hassle, and more time than i have rn

[light finch]

Oo no , please don't trust me that's like putting a bandage on a .338 wound and telling whatever is left it's fine. Did it as a temporary fix and let's say it stayed 2+ years

[frank plover]

that does sound like me

[light finch]

Service giving issues or just "I'll do it later" vibe

[light finch]

Point proven

[frank plover]

once valve comes out with their gaming os i might switch

but i just know my adobe media encoder server will cease to function if i do it rn

and stuff just works rn

[light finch]

Proton works wonders , I use https://github.com/dockur/windows for windows exclude bs (fk Adobe) and have a VM with windows11 on proxmox (with GPU passtrue) for kernel level anticheat games

[frank plover]

fuck adobe indeed

anyway so mongo

do i need the router

i guess so

everysthing else is 0KB

i misremembered i have 6 gigs left on the ssd

[light finch]

yes

[light finch]

did you ever run games on this evoirment ?

if yes then go and delte all the cash files freed like 62gb other day on my vm by doing that

[frank plover]

huh what this

[light finch]

leave default

basicly makes it a service instead of a app

[frank plover]

that would be cool

keep it on the server machine and i just connect locally from my personal laptop

oh is this like accessing network attached storage using the credentials of the server machine?

that is not needed though

im guessing i wont need the compass gui

[light finch]

kinda but not exaclty. but if you want pain do local

[light finch]

install on personal connect to it over net

its very big in size

[frank plover]

is everything just a fucking electron app?

[frank plover]

the delay suggests youve been making this meme just right now havent you

[light finch]

https://tenor.com/view/maybe-perhaps-gif-25738848

[frank plover]

okay installed?

https://tenor.com/view/finding-nemo-bags-floating-stuck-now-what-gif-5473087

do i just

mongodb://192.168.100.69:27017

[light finch]

perhaps

[frank plover]

dont have a database set up yet

[light finch]

hehe someone didnt read the docs

[frank plover]

yea tldr

oo it has a shell

[light finch]

😂

could also maby have used the test db to welp test

[frank plover]

oh there is one?

[light finch]

yup "test"

[frank plover]

yea ill have to look into that

what in the fuck 2 gigabytes

[light finch]

https://www.mongodb.com/docs/manual/administration/install-community/?operating-system=windows&windows-installation-method=zip

[frank plover]

might ditch it tbf

[frank plover]

ah that explains it. why would it even install.

[light finch]

nice ai, and i whould have sugested it but u insited on json so ummm, sqllite and json are like water and fire both wanting to cost you your soul

[frank plover]

ah huh

i mean i didnt insist just thought what i was considering up to right now

[light finch]

then maby use it , tbh all road leads to containers eventually

[frank plover]

once i will feel the need to migrate and jump ships, machines hardware and providers and server hosts and everything

but im not a developer so all good

just shows

oh god

[light finch]

fun , good thing i also do hosting and management for $

[frank plover]

i have my own domain and my own lil server machine for this purpose.

[light finch]

then USE IT 🫠

[frank plover]

i dooooo

ive just never done this shit before

oh how great

ive never touched express before

looks like another view based js framework because we didnt have enough

[light finch]

what the mogo or the hole making app , take to prod parts ?

[light finch]

https://tenor.com/view/peace-out-gif-3584473422170938815

[light finch]

i hate js

[frank plover]

any

im a python boy

ive had two years of webdev in uni and 2 (3because i failed) years of databases and i loathe and despise both

i dont remember anything

[light finch]

sql or nosql db

[frank plover]

sql

[light finch]

no wonder

[frank plover]

it was in java 8 using netbeans

so like 1999

tech

[light finch]

i feels , but todays tech is so mutch nicer

@frank plover i am also guilty

but this is homelab not the prod servers

[frank plover]

i dont know what that means why guilty