Hedgy wants to play with a document store!
-
So, I have this little personal project for which I think a document store is suitable, and I want to know if anyone knows of a good one that works with .NET, and is in-process (as it'll be used on a free Azure web app thingy).
Cue everyone telling me to just use SQLite in 3…2…1…
-
@RaceProUK said in Hedgy wants to play with a document store!:
So, I have this little personal project for which I think a document store is suitable, and I want to know if anyone knows of a good one
Probably not. "Document stores" are for things that have to be "web-scale," AKA on a massive scale, larger than a normal database can handle. A "little personal project" is, by definition, not that kind of project.
If you're going to throw away the massive benefits of ACID and the relational model, you need a really compelling reason. If not, you are TRWTF.
Just use SQL. (-ite or otherwise.)
-
@RaceProUK said in Hedgy wants to play with a document store!:
So, I have this little personal project for which I think a document store is suitable,
-
@masonwheeler OTOH a little personal project may be a good place to at least learn the basics about document stores without creating something that someone else will have to maintain
-
@accalia The only thing wrong with that post is that node won't let me upvote it more than once.
-
Cue everyone telling me to just use SQLite
Here's my suggestion then: use NTFS.
-
@masonwheeler said in Hedgy wants to play with a document store!:
Just use SQL. (-ite or otherwise.)
Called it :D
@accalia said in Hedgy wants to play with a document store!:
@Jarry said in Hedgy wants to play with a document store!:
OTOH a little personal project may be a good place to at least learn the basics about document stores without creating something that someone else will have to maintain
That's what I was thinking. That, and the data I want to store isn't particularly relational or structured: it's actually pretty flat.
-
@masonwheeler said in Hedgy wants to play with a document store!:
@accalia The only thing wrong with that post is that node won't let me upvote it more than once.
i'd have been frist with that flow chart, but i didn't have one ready made.
-
@RaceProUK said in Hedgy wants to play with a document store!:
the data I want to store isn't particularly relational or structured: it's actually pretty flat.
Then use a flat file
-
@RaceProUK said in Hedgy wants to play with a document store!:
Cue everyone telling me to just use SQLite in 3…2…1…
Well, it's actually a fairly competent document store up to the sort of sizes that you'd want to put on a single machine. The trick is to make sure that you've got FTS turned on, since that enables complex indexing of (IIRC) a TEXT column (which I think is implemented as some auxiliary columns, tables and indices). What's better, you've still got ordinary columns and tables available as well for all the structured bits of your data.
I've done a few projects with Hadoop and HDFS, and it was usually best thought of as something that does a very specific set of tasks well and not much else. I've also seen people using Cassandra for document stores; it pretends to be SQL-like but it lacks key things like JOINs and so it really isn't very relational. Also, the people in question had real problems keeping synchronisation between the cassandra db and the other db that they had to use because they needed full relational stuff for other parts of their application. The whole thing amused and horrified me in equal parts. ;)
-
So…
I'm going to use SQLite. It has JSON support nowadays, so it'll do what I need it to do.
-
@RaceProUK said in Hedgy wants to play with a document store!:
So…
I'm going to use SQLite. It has
JSONstring support nowadays, so it'll do what I need it to do.Unless there's something special that you're having the engine do with that JSON, it really shouldn't be able to tell the difference anyways...
-
-
@accalia said in Hedgy wants to play with a document store!:
@RaceProUK said in Hedgy wants to play with a document store!:
So, I have this little personal project for which I think a document store is suitable,
WHAT IF I NEED A FILESYSTEM
I DON'T WANT A SQL FILESYSTEM
-
@ben_lubar said in Hedgy wants to play with a document store!:
I DON'T WANT A SQL FILESYSTEM
Then you should use a git filesystem. I am sure @blakeyrat agrees that would be better than HFS on mac classic.
-
@ben_lubar said in Hedgy wants to play with a document store!:
I DON'T WANT A SQL FILESYSTEM
Might not be a bad thing, actually. Think of the possibilities!
-
@ben_lubar said in Hedgy wants to play with a document store!:
@accalia said in Hedgy wants to play with a document store!:
@RaceProUK said in Hedgy wants to play with a document store!:
So, I have this little personal project for which I think a document store is suitable,
WHAT IF I NEED A FILESYSTEM
I DON'T WANT A SQL FILESYSTEM
-
@accalia
Shouldn't that left arrow go to a box that says "Use Windows"?
-
@izzion Or just point to NTFS anyway. Thanks to FUSE, Mac and Linux can work with NTFS too.
-
@accalia HFS+ no good then?
-
@ben_lubar said in Hedgy wants to play with a document store!:
@accalia said in Hedgy wants to play with a document store!:
@RaceProUK said in Hedgy wants to play with a document store!:
So, I have this little personal project for which I think a document store is suitable,
WHAT IF I NEED A FILESYSTEM
I DON'T WANT A SQL FILESYSTEM
TOO BAD
-
@RaceProUK said in Hedgy wants to play with a document store!:
@accalia HFS+ no good then?
HISSSSSSS! GET THAT CUPERTINO BASED FILESYSTEM OUT OF MY HOUSE