|
yeah, i mean, not to defend nosql in general and in particular not in the popular specifics, but replacing b-trees with flat vectors (column databases) or hashmaps (most popular nosql things) has different tradeoffs which are often useful. notably if your range scans are the most important bit you may be better served by column databases (though you do lose out on the insertion order being something that can be controlled)
|
# ? Nov 22, 2018 13:42 |
|
|
# ? Jun 4, 2024 04:20 |
|
i work for an enterprise nosql company and have debated starting a nosql thread for either here or the grey forums because so many people still have no clue what it is just like the posters here are doing now all nosql ultimately means is that it’s not sql, ie: it’s not storing data in tables rows and columns. beyond that they all work differently and the particular nosql tech you choose should be driven by your specific need the four big ones are: key-value stores, which are basically very fancy hash maps column-base store, which is sort of like an upside down row-based db that takes a bit to explain but has advantages sometimes document-based, this is mongodb and what a lot of people think of when they hear nosql. it basically stores data as entire xml/json documents instead of a series of rows across many tables graph, basically all data is a giant graph of nodes connected to other nodes via ‘relationships’ or ‘predicates’. this one is the most rare because the use cases where it’s actually helpful are narrow and the tech is genuinely pretty difficult to work with. it’s crazy powerful for those few niche cases though and if you can sling sparql you can make fat $$$ stacks
|
# ? Nov 22, 2018 14:46 |
|
why do you need DBs when you have multiplayer excel now?
|
# ? Nov 22, 2018 14:50 |
|
Charun posted:why do you need DBs when you have multiplayer excel now? save millions in oracle licenses with this one weird trick larry hates him!
|
# ? Nov 22, 2018 15:10 |
|
Rex-Goliath posted:i work for an enterprise nosql company and have debated starting a nosql thread for either here or the grey forums because so many people still have no clue what it is just like the posters here are doing now Do it, you dirty bitch. Talk nosql to me.
|
# ? Nov 22, 2018 16:04 |
|
Charun posted:why do you need DBs when you have multiplayer excel now? i hate you
|
# ? Nov 22, 2018 16:30 |
|
Rex-Goliath posted:i work for an enterprise nosql company and have debated starting a nosql thread for either here or the grey forums because so many people still have no clue what it is just like the posters here are doing now u talking triple store then? is there one I can load 100 billion triples in and get, idk , 10-100 million traversals per second out of
|
# ? Nov 22, 2018 16:56 |
|
Kevin Mitnick P.E. posted:u talking triple store then? is there one I can load 100 billion triples in and get, idk , 10-100 million traversals per second out of yeah triple store and i have no clue what kind of numbers dedicated graph dbs are capable of i’ve never worked with any of them
|
# ? Nov 22, 2018 17:06 |
|
Rex-Goliath posted:yeah triple store and i have no clue what kind of numbers dedicated graph dbs are capable of i’ve never worked with any of them if anyone knows, they’re not telling. cynical shoulder demon says it’s because a 3-column postgres table has better numbers
|
# ? Nov 22, 2018 17:12 |
|
does mongodb still have no password by default? can't stop thinking bout all those public instances listening on 0.0.0.0 with no password
Pile Of Garbage fucked around with this message at 17:59 on Nov 22, 2018 |
# ? Nov 22, 2018 17:20 |
|
Don't column based stores use SQL?
|
# ? Nov 22, 2018 17:57 |
|
Charun posted:why do you need DBs when you have multiplayer excel now? all_customer_data(1)_final(1)_backup.xlsx
|
# ? Nov 22, 2018 20:16 |
|
Pile Of Garbage posted:does mongodb still have no password by default? can't stop thinking bout all those public instances listening on 0.0.0.0 with no password afaik this is still default behavior, yeah lol
|
# ? Nov 22, 2018 20:19 |
pseudorandom name posted:Don't column based stores use SQL? i dont understand their uses in practice but ive had them thrown at me often enough that i ended up reading the docs and no, best i saw was failure to get even to sql:2003
|
|
# ? Nov 22, 2018 20:54 |
|
Speaking of databases does mssql have anything like redis to store non tabular data. Like a key and value
|
# ? Nov 22, 2018 21:02 |
|
BIGFOOT EROTICA posted:Speaking of databases does mssql have anything like redis to store non tabular data. Like a key and value do you mean like a column name and then subsequent values underneath?
|
# ? Nov 22, 2018 22:01 |
|
Boiled Water posted:do you mean like a column name and then subsequent values underneath? can you use it with a distributed map reduce function in erlang?
|
# ? Nov 22, 2018 22:05 |
|
BIGFOOT EROTICA posted:Speaking of databases does mssql have anything like redis to store non tabular data. Like a key and value I think they recommend cosmosdb or redis for that kind of thing. if it’s important data you code it properly in regular tables in mssql
|
# ? Nov 22, 2018 22:07 |
|
yeah I mean that’s what I do now, it’s a table with a constrained and unique column so there can never be more than one row. It’s just lovely and hacky when you want to store 2-3 single values
|
# ? Nov 22, 2018 22:14 |
|
never go on redis
|
# ? Nov 22, 2018 23:28 |
|
BIGFOOT EROTICA posted:yeah I mean that’s what I do now, it’s a table with a constrained and unique column so there can never be more than one row. It’s just lovely and hacky when you want to store 2-3 single values its fine.
|
# ? Nov 23, 2018 04:19 |
nekko make the db thunderdome thread
|
|
# ? Nov 23, 2018 05:21 |
|
your database is a piece of poo poo
|
# ? Nov 23, 2018 05:30 |
|
Chris Knight posted:never go on redis why not?
|
# ? Nov 23, 2018 05:48 |
|
Rex-Goliath posted:i work for an enterprise nosql company and have debated starting a nosql thread for either here or the grey forums because so many people still have no clue what it is just like the posters here are doing now note that microsoft sql server supports all four of those, and does so using t-sql.
|
# ? Nov 23, 2018 06:38 |
|
Shaggar posted:I think they recommend cosmosdb or redis for that kind of thing. if it’s important data you code it properly in regular tables in mssql cosmodb: for when all the money in the world just isn’t enough
|
# ? Nov 23, 2018 09:33 |
|
akadajet posted:why not? because redis sounds like reddit
|
# ? Nov 23, 2018 10:37 |
|
20 minutes, I have had windows installed for 20 minutes on this spare hard drive entirely so I can play battlefield 5 https://twitter.com/LuigiThirty/status/1065901845246353408 WHAT
|
# ? Nov 23, 2018 10:47 |
|
Luigi Thirty posted:20 minutes, I have had windows installed for 20 minutes on this spare hard drive entirely so I can play battlefield 5 people complain when the error messages are vague and they complain when theyre specific but a really dumb reason WHICH DO YOU WANT?
|
# ? Nov 23, 2018 12:30 |
|
Guess the army didn't want you.
|
# ? Nov 23, 2018 12:30 |
|
why does MS even bother offering mssql when access and excel are the perfect database solution/???
|
# ? Nov 23, 2018 14:00 |
|
Fiedler posted:note that microsoft sql server supports all four of those, and does so using t-sql. The graph support is a little limited but yeah sql server is incredible
|
# ? Nov 23, 2018 14:46 |
|
Most "big data" solutions got be implemented far more cheaply by just buying a bigger server and sticking sql server on it
|
# ? Nov 23, 2018 14:47 |
|
"buying a bigger server and sticking sql server on it" isn't very buzzwordy
|
# ? Nov 23, 2018 15:04 |
|
Fiedler posted:note that microsoft sql server supports all four of those, and does so using t-sql. i’m aware but the fact i’ve never even run into a client threatening to switch to it or even any sales material on how to address it if they come up during a sale tells me it probably isn’t that performant. idk though i’ve never worked with it. their documentation comes up a lot any time i’m googling xquery stuff
|
# ? Nov 23, 2018 15:20 |
|
Wheany posted:"buying a bigger server and sticking sql server on it" isn't very buzzwordy what if cloud?
|
# ? Nov 23, 2018 16:22 |
|
Fairly certain that you could spin stored procs as being "serverless" somehow (you just define your function and a schedule in ssms and bam! done. No nasty deployment or anything)
|
# ? Nov 23, 2018 17:59 |
|
Chris Knight posted:what if cloud? okay, i'm opening my wallet a little
|
# ? Nov 23, 2018 21:44 |
|
Rex-Goliath posted:i’m aware but the fact i’ve never even run into a client threatening to switch to it or even any sales material on how to address it if they come up during a sale tells me yes i'm sure your customers make lots of bad decisions
|
# ? Nov 23, 2018 22:46 |
|
|
# ? Jun 4, 2024 04:20 |
pointsofdata posted:The graph support is a little limited but yeah sql server is incredible never support graph imo
|
|
# ? Nov 24, 2018 01:24 |