Questions tagged [schemaless]

73 questions
120
votes
12 answers

How to export collection to CSV in MongoDB?

How do you export all the records in a MongoDB collection to a .csv file? mongoexport --host localhost --db dbname --collection name --type=csv > test.csv This asks me to specify name of the fields I need to export. Can I just export all the fields…
Succeed Stha
  • 1,687
  • 2
  • 12
  • 13
45
votes
6 answers

What's the attraction of schemaless database systems?

I've been hearing a lot of talk about schema-less (often distributed) database systems like MongoDB, CouchDB, SimpleDB, etc... While I can understand they might be valuable for some purposes, in most of my applications I'm trying to persist objects…
Chet
  • 21,375
  • 10
  • 40
  • 58
35
votes
4 answers

Using a Filesystem (Not a Database!) for Schemaless Data - Best Practices

After reading over my other question, Using a Relational Database for Schema-Less Data, I began to wonder if a filesystem is more appropriate than a relational database for storing and querying schemaless data. Rather than just building a file…
18
votes
5 answers

What is the best open source solution for storing time series data?

I am interested in monitoring some objects. I expect to get about 10000 data points every 15 minutes. (Maybe not at first, but this is the 'general ballpark'). I would also like to be able to get daily, weekly, monthly and yearly statistics. It is…
lorg
  • 1,160
  • 1
  • 10
  • 27
13
votes
3 answers

Django and NoSQL, any ready-to-use library?

So far Django has good integration with several RDBMS. NoSQL, schema-less and document-oriented DBMS are picking up. What's the status of integration those on-trend and fashionable DBMSes with Django? Are there any production-ready or at least…
Viet
  • 17,944
  • 33
  • 103
  • 135
11
votes
5 answers

What is couchdb, for what and how should I use it?

I hear a lot about couchdb, but after reading some documents about it, I still don't get why to use it and how. Could you clarify this mystery for me?
Natim
  • 17,274
  • 23
  • 92
  • 150
9
votes
4 answers

Best practices to access schema-less data?

I am toying with RDF, and in particular how to access information stored in a rdf storage. The huge difference from a traditional relational database is the lack of a predefined schema: in a relational database, you know that table has those…
Stefano Borini
  • 138,652
  • 96
  • 297
  • 431
8
votes
1 answer

Are there any general patterns for designing classes for schemaless databases in .NET?

I have done a little bit of work with mongoDB in C# but all of my code is still in development. I am wondering what useful patterns people have found in evolving their domain classes over time as new properties are created, altered and removed. I…
Matthew Nichols
  • 4,866
  • 4
  • 41
  • 48
8
votes
2 answers

Array, EAV, Serialized LOB for custom fields?

I've been trying to answer a complex Mysql data structure problem for custom fields for an online app. I'm fairly new to Mysql so any input is appreciated. The current database is a relational database and each user of the service will share the…
teamcrisis
  • 709
  • 1
  • 6
  • 14
8
votes
2 answers

Schemaless Support for Elastic Search Queries

Our REST API allows users to add custom schemaless JSON to some of our REST resources, and we need it to be searchable in Elasticsearch. This custom data and its structure can be completely different across resources of the same type. Consider this…
ecrisostomo
  • 181
  • 2
  • 7
7
votes
4 answers

Serializiation with Protocol Buffers in a Schemaless Database

We're using MySQL to store schemaless data (see: Using a Relational Database for Schemaless Data for the solution inspired by how FriendFeed uses MySQL to store schemaless data). One big table holds all entities for our application: CREATE TABLE…
7
votes
2 answers

Entity groups in Google App Engine Datastore

So I have an app that if I'm honest doesn't really need transactional integrity (lots of updates, none of them critical). So I was planning on simply leaving entity groups by the wayside for now. But I'd still like to understand it (coming from a…
citronic
  • 9,868
  • 14
  • 51
  • 74
5
votes
2 answers

Schemaless financial data, and NoSQL?

We have an application that works with financial data that is schemaless. More accurately, the shemaless data is information about an order, where fields are customized by the merchant. Consistency and durability is important. Because of how dynamic…
Luke
  • 13,678
  • 7
  • 45
  • 79
4
votes
1 answer

Elasticsearch: is there a way to declare for all (possibly dynamic) subfields of an object field as string?

I have a doc_type with a mapping similar to this very simplified one: { "test":{ "properties":{ "name":{ "type":"string" }, "long_searchable_text":{ "type":"string" }, …
Rafael S. Calsaverini
  • 13,582
  • 19
  • 75
  • 132
3
votes
2 answers

Indexing entire XML document on SOLR 7 with no field specification

I would try to put an xml document on SOLR (now i'm using 7.3.0 version) without set specific fields in data-config or putting one tag to get all the others. I tried with schemaless mode but I didn't get any document back. Is it possible to do this…
1
2 3 4 5