[Boards: 3 / a / aco / adv / an / asp / b / bant / biz / c / can / cgl / ck / cm / co / cock / d / diy / e / fa / fap / fit / fitlit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mlpol / mo / mtv / mu / n / news / o / out / outsoc / p / po / pol / qa / qst / r / r9k / s / s4s / sci / soc / sp / spa / t / tg / toy / trash / trv / tv / u / v / vg / vint / vip / vp / vr / w / wg / wsg / wsr / x / y ] [Search | Free Show | Home]

I hate SQL

This is a blue board which means that it's for everybody (Safe For Work content only). If you see any adult content, please report it.

Thread replies: 11
Thread images: 1

File: nosql-plm.png (25KB, 278x256px) Image search: [Google]
nosql-plm.png
25KB, 278x256px
I hate SQL. I'm trying NoSQL databases now because I don't wanna reinvent
the weel but companies are in fact doing so. Facebook has Unicorn DB
and RocksDB. Google has its own databases too. SQL is dead for huge services
because there is always a faster way that makes things simpler and cheaper
even if they have to pay programmers to write an entire DB library.

Nobody tries to improve because everyone just learn SQL and PHP and want
something that just work. They can't see that it is just not good enough.

I tried Berkeley DB (old well-stablished key-value database written in C).
Now I need something that can store a hierarchy such as
[company]/users/[user]/[items]
Some say that it is possible to store such hierarchy in a key-value
database in a hackerish way by marshalling the key. The problem is that
the absolute path will be written multiple times in similar ways.
I need a navigational database, something like a file system, capable
of storing binary data on disk, each path node is written just once and
can be followed easily.

I want a library written in C, without any interpreted language
like SQL or JSON or Redis language, just plain API. I want something so fast that I could
run it on an Arduino or build a system as large as Facebook. Will
I have to write it myself too? Are there free software alternatives?
>>
>>56252787
Yes, MySQL or PostgreSQL.

Get over yourself. SQL is fine for almost anything. That's the beauty of it, you could still achieve reasonable performance at a few million records.

Also, it's good at representing hierarchical information like what you have described. Stop being pretentious.
>>
>>56254586
This. So far benchmarks have shown that even for NoSQL work, PostgreSQL still has better performance with it's JSON functions.
>>
>>56252787
Unless you are Facebook or Google, using SQL shouldn't make a noticeable performance difference
>>
>I need a navigational database, something like a file system, capable
of storing binary data on disk, each path node is written just once and
can be followed easily.


This can be achieved with a graph database OP. It's much simpler to use than traditional SQL imo.
>>
>weel
>>
>>56252787
Have you ever given it thought that SQL might hate you?
>>
How fucking retarded do you have to be to not be able to use SQL? Literally all of them allow you to restore binary blobs now.
>>
>>56254623
And they just added parallel multi threaded queries
>>
>>56252787
Dude, do you even shart your databases?
>>
Databases are cumbersome and there's no evading it. If you anticipate any complexity growth in your app, then not using SQL is just ensuring you have horrible problems in the future.
Thread posts: 11
Thread images: 1


[Boards: 3 / a / aco / adv / an / asp / b / bant / biz / c / can / cgl / ck / cm / co / cock / d / diy / e / fa / fap / fit / fitlit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mlpol / mo / mtv / mu / n / news / o / out / outsoc / p / po / pol / qa / qst / r / r9k / s / s4s / sci / soc / sp / spa / t / tg / toy / trash / trv / tv / u / v / vg / vint / vip / vp / vr / w / wg / wsg / wsr / x / y] [Search | Top | Home]

I'm aware that Imgur.com will stop allowing adult images since 15th of May. I'm taking actions to backup as much data as possible.
Read more on this topic here - https://archived.moe/talk/thread/1694/


If you need a post removed click on it's [Report] button and follow the instruction.
DMCA Content Takedown via dmca.com
All images are hosted on imgur.com.
If you like this website please support us by donating with Bitcoins at 16mKtbZiwW52BLkibtCr8jUg2KVUMTxVQ5
All trademarks and copyrights on this page are owned by their respective parties.
Images uploaded are the responsibility of the Poster. Comments are owned by the Poster.
This is a 4chan archive - all of the content originated from that site.
This means that RandomArchive shows their content, archived.
If you need information for a Poster - contact them.