On Wed, 15 Jul 2015 17:22:36 +0200
Sergej Jure?ko wrote:
> An idea I?ve had a while ago was to implement functions for json
> documents (using sqlite3_create_function_v2)
>
> Json would be stored in a text column. You would need to define 2
> functions:
> -
I will probably get around to doing it in the next few months. Hopefully I
have the time, right now I'm very busy. I will post to this message board
when I'm done.
Sergej
An idea I?ve had a while ago was to implement functions for json documents
(using sqlite3_create_function_v2)
Json would be stored in a text column. You would need to define 2 functions:
- docget(document,key1,subval1,subval2,?)
- docset(document,key1,subval1,subval2,..,val)
Last parameter of
I'm beginning to understand some of the implementation challenges here.
Eric, it'd be great to get that open sourced. I can tell you at least
I will jump and prototype on it.
Sergej and Roger, I do like this potential idea as well. Of course,
now it's a custom sqlite, but at least the job gets
On Wed, Jul 15, 2015 at 10:03 AM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 07/15/2015 08:22 AM, Sergej Jure?ko wrote:
> > What do you guys think? Is it stupid, could it be improved?
>
> I recommend looking at Mongodb and Postgres first to see how they do
>
Hi Hayden,
On 14.07.2015 03:43, Hayden Livingston wrote:
> Is there a concept of a schema-less JSON SQLite DB?
>
> My reason is simple: versioning. We have lot of business metrics that
> get updated let's say once a month, and we need to be agile to get
> them. Right now, we just put the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/15/2015 08:22 AM, Sergej Jure?ko wrote:
> What do you guys think? Is it stupid, could it be improved?
I recommend looking at Mongodb and Postgres first to see how they do
queries. It would be better to be compatible with them where
practical,
Given the number of the threads in the list, it seems a
> lot of people want hierarchical data in SQLite :-)
>
Throwing in another $.02 here, my company had a need to ingest JSON of
various formats into SQLite databases in low-power embedded devices. We
wrote the utility program described here:
[mailto:halivingston at gmail.com]
Gesendet: Dienstag, 14. Juli 2015 19:22
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] Schema-less JSON SQLite DB?
Wow, this is the killer feature no-one told me about. I can get rid of types?
How does this work under-the-hood?
SELECT * FROM TABLE WHERE
On Wed, Jul 15, 2015 at 2:14 AM, Alek Paunov wrote:
> Hi Hayden,
>
> On 14.07.2015 03:43, Hayden Livingston wrote:
>
>> Is there a concept of a schema-less JSON SQLite DB?
>>
>> My reason is simple: versioning. We have lot of business metrics that
>> get updated let's say once a month, and
On Tue, 14 Jul 2015 10:22:02 -0700, Hayden Livingston
wrote:
> Wow, this is the killer feature no-one told me about.
> I can get rid of types? How does this work under-the-hood?
>
> SELECT * FROM TABLE WHERE FooColumn > 50
>
> And I've stored "Something" in that column in some row.
> What's the
On 14 Jul 2015, at 6:22pm, Hayden Livingston wrote:
> Wow, this is the killer feature no-one told me about. I can get rid of
> types? How does this work under-the-hood?
>
> SELECT * FROM TABLE WHERE FooColumn > 50
>
> And I've stored "Something" in that column in some row. What's the
that does indeed look interesting. Embedded DB is the only problem here.
On Mon, Jul 13, 2015 at 11:01 PM, Darren Duncan
wrote:
> Have a look at PostgreSQL 9.4 as well and its new JSONB data type. Gives
> you the goods of relational and hierarchical databases in one place,
> including the
Wow, this is the killer feature no-one told me about. I can get rid of
types? How does this work under-the-hood?
SELECT * FROM TABLE WHERE FooColumn > 50
And I've stored "Something" in that column in some row. What's the behavior?
I don't want to take up your time, so if there's a document I
Have a look at PostgreSQL 9.4 as well and its new JSONB data type. Gives you
the goods of relational and hierarchical databases in one place, including the
querying and indexing. -- Darren Duncan
On 2015-07-13 5:43 PM, Hayden Livingston wrote:
> Is there a concept of a schema-less JSON
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/13/2015 08:00 PM, Hayden Livingston wrote:
> Does your code also map object hierarchies in json?
Yes, but thankfully I don't have much of them. Essentially the top
level of the object has a unique id (SQLite allocated), and then other
tables
We use SQLite as a library and we don't want to migrate to a server situation.
So it seems using the month-to-month approach you outline is
reasonable and not outrageous. Good to know.
Thanks for the tip on schema modifications which get automatically
upgraded on read. This is a great feature. I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/13/2015 05:43 PM, Hayden Livingston wrote:
> Is there a concept of a schema-less JSON SQLite DB?
What exactly is it you want? A schema-less database? A JSON
database? Using SQLite to store JSON? (It is unclear if you mean
something like
Is there a concept of a schema-less JSON SQLite DB?
My reason is simple: versioning. We have lot of business metrics that
get updated let's say once a month, and we need to be agile to get
them. Right now, we just put the version in the SQLite file, and then
make sure no queries cross the
19 matches
Mail list logo