Re: [sqlite] Open source projects using sqlite

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 17/01/12 05:01, Matt Young wrote:
> Mainly grouping sqlite applications in the embedded environment,
> hopefully generating some reusable methods of accessing the sqlite
> internals.

I'm still totally confused about what you are trying to achieve.  There is
exactly one way of accessing SQLite internals - start here:

  http://www.sqlite.org/c3ref/intro.html

There are lots of wrappers for other programming languages, but in an
embedded environment you are far more aware of your constraints (ram, cpu,
response times, caching, programming languages, library versions etc) and
will need to adjust to your circumstances.

> One example might  be a reusable method for storing BSON objects, so
> differing BSON applications share a common table/column  view of
> BSON.

Huh?  The only BSON I have used and can find any mention of is the binary
JSON representation introduced by MongoDB.  That style of data
representation and the relational model used by SQL do not mix except for
the most superficial cases.

> Another example is reusing parts of fossil code in a group ware 
> application. The two projects might generate a common table view of
> what a user is, hence generating some common code to manage user id
> tables.   Then you have folks doing something completely unrelated, but
> still using sqlite and still needing a self contained user id
> management.  So, import the standard user id function from the sqlite
> repositories and be done with it.

That sounds like you want published standard schemas.  But even something
like a user is going to depend on the platform and usage.  The admin user
for a router only needs a username and password stored.  A user that is
allowed data storage will need username, password, a home directory,
possibly a quota and platform specific id.  A more complicated one would
also require group membership information.  Yet another may need to store
users preferred language.  A user that has to work across machines would
need to plug into existing Active Directory or LDAP schemas.

It still isn't clear what you want as your messages have been all over the
place mentioning API abstractions, unrelated serialization formats,
schemas, open source and embedded without showing what problem you want to
solve.

In any event if you want someone else to do the work to produce a catalog
of whatever it is you want, then you'll need to provide a reason why they
would do that for your benefit.  If you want to do itself then go ahead
and just do it.  You can use a search engine to find the underlying data
and a wiki or similar as a place to collate it.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAk8VxjUACgkQmOOfHg372QR4ewCgzI5IPciF8juhfY7j5FDyu80a
BJYAnjKeEt4aY4mY8W1z26DUxjJoOISU
=g/LF
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Open source projects using sqlite

[Matt Young]

Another example is reusing parts of fossil code in a group ware
application. The two projects might generate a common table view of what a
user is, hence generating some common code to manage user id tables.   Then
you have folks doing something completely unrelated, but still using sqlite
and still needing a self contained user id management.  So, import the
standard user id function from the sqlite repositories and be done with it.

On Tue, Jan 17, 2012 at 5:01 AM, Matt Young  wrote:

> Mainly grouping sqlite applications in the embedded environment, hopefully
> generating some reusable methods of accessing the sqlite internals. One
> example might  be a reusable method for storing BSON objects, so differing
> BSON applications share a common table/column  view of  BSON.
>
>
> On Mon, Jan 16, 2012 at 11:58 PM, Roger Binns wrote:
>
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> On 16/01/12 21:46, Matt Young wrote:
>> > Group projects, collected together because sqlite is the common
>> > foundation.  Would be nice?
>>
>> You'll need to use longer sentences.  What exactly do you want to achieve
>> and who do you want to do the work of grouping projects?
>>
>> There is a list of well known users at this page although parts are dated:
>>
>>  http://www.sqlite.org/famous.html
>>
>> You can find numerous open source projects using SQLite by searching at
>> Github, Bitbucket, Google Code and SourceForge.
>>
>> Roger
>> -BEGIN PGP SIGNATURE-
>> Version: GnuPG v1.4.11 (GNU/Linux)
>>
>> iEYEARECAAYFAk8VKh0ACgkQmOOfHg372QS9egCdElHp77YiBI+2BjxtvjmtqLem
>> Z9UAoMkmbxTgve0za1tUFJwv74E2w4kq
>> =t+i9
>> -END PGP SIGNATURE-
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Open source projects using sqlite

[Matt Young]

Mainly grouping sqlite applications in the embedded environment, hopefully
generating some reusable methods of accessing the sqlite internals. One
example might  be a reusable method for storing BSON objects, so differing
BSON applications share a common table/column  view of  BSON.

On Mon, Jan 16, 2012 at 11:58 PM, Roger Binns  wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 16/01/12 21:46, Matt Young wrote:
> > Group projects, collected together because sqlite is the common
> > foundation.  Would be nice?
>
> You'll need to use longer sentences.  What exactly do you want to achieve
> and who do you want to do the work of grouping projects?
>
> There is a list of well known users at this page although parts are dated:
>
>  http://www.sqlite.org/famous.html
>
> You can find numerous open source projects using SQLite by searching at
> Github, Bitbucket, Google Code and SourceForge.
>
> Roger
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.11 (GNU/Linux)
>
> iEYEARECAAYFAk8VKh0ACgkQmOOfHg372QS9egCdElHp77YiBI+2BjxtvjmtqLem
> Z9UAoMkmbxTgve0za1tUFJwv74E2w4kq
> =t+i9
> -END PGP SIGNATURE-
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Open source projects using sqlite

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 16/01/12 21:46, Matt Young wrote:
> Group projects, collected together because sqlite is the common 
> foundation.  Would be nice?

You'll need to use longer sentences.  What exactly do you want to achieve
and who do you want to do the work of grouping projects?

There is a list of well known users at this page although parts are dated:

  http://www.sqlite.org/famous.html

You can find numerous open source projects using SQLite by searching at
Github, Bitbucket, Google Code and SourceForge.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAk8VKh0ACgkQmOOfHg372QS9egCdElHp77YiBI+2BjxtvjmtqLem
Z9UAoMkmbxTgve0za1tUFJwv74E2w4kq
=t+i9
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Open source projects using sqlite

[Matt Young]

Group projects, collected together because sqlite is the common
 foundation.  Would be nice?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users