If nothing helps im sure gpt can extract some

@b2plane the query seems as good as it gets.
what i find strange is that many to many table user_conversation
can multiple users create the same conversation? or does the table actually track who is added to a group convo.
if its only about the creation the creator should be linked as foreign key "creator" in conversation.
however if the table does represent the list of users of a conversation, this is a good solution.

then your user has 0,1 profiles, and a profile 1,1 users.
thats a difference.

since user is always present use user primarily. use profile when profile content should be displayed.

infected mushroom on full blast

@SoldierOfCode not anymore, there's a blanket!

Factorio should do the trick.

Look up BNF

OK=ACK

my favourite are banks.
max 5 characters, only alphanumeric lowercase.

yes its a max limit not minimum

@LotsOfCaffeine did indeed immediately check it into git after this, i really expected more from them tho

@netikras var a=7;

@asgs imprecise, would it remove all spaces between any curly braces?

lets rename devrant to devpraise to stay positive

short: it depends

long:
if you want to save 5 lines of config data, a json is perfectly okay. or if you want to send a small network object to a client application too.

if you try to save a million users with a million config entries, a json becomes very impractical, it takes forever to read save or search, you have no query abilities, filters or access by more than one user at a time.
in general, if you would need that file more than once a second, you are past the limit imo.

You usually define your data structure before making it.
if you have relations (eg a customer having orders) thats a pointer towards a relational database.
if you have a local config file with a few lines, that you always load as a whole anyways on startup, thats the use case of a local file.
it is probably good to note that json may not always be the best notation for each case either. by my experience its mostly used for data transmission in networking.

if i can figure out your password is
password12 i can guess it may be password13 next month,.
theres no security in that.
in fact if you know the password is changed regularly you can brute force for 8 letters+index instead of 10 letters in this case, vastly reducing the search space.
more rules reduce it further.
also dictionary attacks are very effective in this case

never heard

java has its reasons to exist as many other language. depends what you ise it for.
that being said, javascript is indeed fucking stupid

fakeupdate(dot)net
in fullscreen

*ignites nuke*
careful what you wish for

americans be like: huh thats chill

write a test

//idea
like this?

I think the people objecting terminology are the only people with racist structures.
all other people just see it as a normal term hence are not racist.

@Tounai maybe they dont know what database or cloud provider to choose, so they expect someone who knows them all and can make a decision based on that

oh you need a login, alright want a crappy one for one week on top of the deadline or a good one for two weeks?

rubics cube visualization and automatic solving

@NoMad its one you install around a corner via web (google it).
the one in the playstore is a fake

@NoMad Youtube Vanced in that case then

adblock anyone?

@MostafaGhanbari as a german...
no