>>> Your data is from MongoDB :) Note they do have an extended JSON to >>> deal with types like ObjectId, binary and dates: >> Yes, it is. But I control the document structure and it does not have >> any types that can't be converted easily after a pull over the net. > >Does that mean you can make it individual fields instead of a list? As >Petite Abeille pointed out you need to do SQL things the SQL way or you >will end up in a world of hurt.
You need to use a RELATIONAL datastore in a RELATIONAL way. This applies whether your access method is SQL, ISAM, HIDAM, BDAM or VSAM. If the underlying datastore is not relational, you may also be able to use one (or more) of the mentioned access methods. However, then you will be able to store non-relational data in it and manupulate it easily. SQLite is a RELATIONAL datastore that uses the SQL access method. Please do not confuse the access method and the datastore. The datastore defines the properties of the filing cabinets, and the access method the language spoken by the filing clerk. Any filing clerk can be taught to use many underlying storage cabinet systems, just as any given storage cabinet system may be accessed by any number of clerks speaking different languages. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
