Colloidal

joined 1 week ago
[–] Colloidal 1 points 14 hours ago

I'm not particularly fond of cuck licenses.

 

It's pages and pages of this. Maybe you want to restrict who can log in and create repositories.

[–] Colloidal 1 points 3 days ago

Got it, thanks.

[–] Colloidal 1 points 3 days ago (2 children)

Hold a sec. Rolling your own RDBMS out of a NoSQL database is insane. But is the opposite feasible? Wouldn't it be a simple table with two columns: a key and a JSON blob?

[–] Colloidal 2 points 3 days ago

Gotcha. Thanks!

[–] Colloidal 1 points 3 days ago* (last edited 3 days ago) (2 children)

Right, RDBMS for object permanence is a pain. It’s meant as efficient data storage and retrieval. But I counter that a huge amount of data problems are of that kind, and using object permanence for general database applications seems very contrived. I’m imagining loading a huge amount of data to memory to filter the things you need, essentially rolling your own DBMS. Am I missing something?

[–] Colloidal 1 points 3 days ago

I don't know if it was you, but thanks for the initiative.

[–] Colloidal 2 points 3 days ago

Still under the umbrella and control of the Mozilla organization. Just a different subsidiary from Firefox. The concerns are very valid.

[–] Colloidal 5 points 3 days ago

Right, and you’d never do a search for messages with a particular reaction, so there’s no functionality loss is this use case.

[–] Colloidal 4 points 3 days ago (4 children)

What I’m hearing is that they’re very different beasts for very different applications. A typical web app would likely need both.

[–] Colloidal 9 points 3 days ago* (last edited 3 days ago) (8 children)

Let me see if I got it. It would be like a denormalized table with a flexible number of columns? So instead of multiple rows for a single primary key, you have one row (the file), whose structure is variable, so you don’t need to traverse other tables or rows to gather/change/delete the data.

The downsides are the usual downsides of a denormalized DB.

Am I close?

41
What is NoSQL good for? (self.learn_programming)
 

I’m versed enough in SQL and RDBMS that I can put things in the third normal form with relative ease. But the meta seems to be NoSQL. Backends often don’t even provide a SQL interface.

So, as far as I know, NoSQL is essentially a collection of files, usually JSON, paired with some querying capacity.

  1. What problem is it trying to solve?
  2. What advantages over traditional RDBMS?
  3. Where are its weaknesses?
  4. Can I make queries with complex WHERE clauses?
[–] Colloidal 1 points 3 days ago

That’s very Windows-y.

[–] Colloidal 6 points 3 days ago (1 children)

Reduce, Reuse, Recycle; in that order. Recycling is always the most expensive option.

view more: next ›