On 7/12/18, dmp wrote:
>
> I use a dump
> in my interface which I used with diff to compare changes in my
> personal expense database. This was to insure changes introduced in work
> on the interface were not screwing things up. Very helpful to insure
> your not introducing bugs.
I am glad that h
Randall wrote:
> My wishlist is:
> (o) Allow humans to view the contents of a DB without custom tools.
If what is meant here is a generic tool that opens/views any particular
file format, db context here, then there are tools including
the generic db gui that I have been working on for years.
>
On 7/11/18, Randall Smith wrote:
>
> My wishlist is:
>
> (o) Allow humans to view the contents of a DB without custom tools.
SQLite database file are binary. That is a necessity in any format
that needs to store binary data. On the other hand, the SQLite
database file format is carefully and fu
On 11 Jul 2018, at 6:01pm, Randall Smith wrote:
> (o) Allow humans to view the contents of a DB without custom tools.
> (o) Have a way to see what has changed between V1 and V2 of a database, e.g.,
> for a "change review."
SQL is based around Ted Codd's view of relational databases. One of the
On 2018/07/10 8:27 PM, Randall Smith wrote:
> One follow-up: Do you know if the dump output is "deterministic" over
> time? That is, if I diff two dumps taken at different times, will the
> unchanged material be in the same order and so on? Or is the ordering
> effectively random?
> My underly
On Tuesday, 10 Jul 2018 2:27 PM -0400, Randall Smith wrote:
> My underlying question is "can text-comparing two DB dumps be used
> to determine what has changed?"
I don't know if it will meet your needs, but I've written a script for
my own purposes to compare DB changes. Since it's fairly sho
On 2018/07/10 8:27 PM, Randall Smith wrote:
One follow-up: Do you know if the dump output is "deterministic" over
time? That is, if I diff two dumps taken at different times, will the
unchanged material be in the same order and so on? Or is the ordering
effectively random?
My underlying questi
From: Simon Slavin
> I'm curious if there is some standard or normal way to convert a SQLite DB to
> a text representation, and then recreate the DB content from the text.
> Naively, this seems hard or impossible as a general problem, but perhaps I am
> missing something.
Yep. It's done
On 10 Jul 2018, at 1:52am, Randall Smith wrote:
> I'm curious if there is some standard or normal way to convert a SQLite DB to
> a text representation, and then recreate the DB content from the text.
> Naively, this seems hard or impossible as a general problem, but perhaps I am
> missing so
ll Smith
>Sent: Monday, 9 July, 2018 18:53
>To: sqlite-users@mailinglists.sqlite.org
>Subject: [sqlite] Round-tripping SQLite back and forth between text
>representation.
>
>I'm curious if there is some standard or normal way to convert a
>SQLite DB to a text representation, an
does it have to be text? There was serialization added to sqlite
https://www.sqlite.org/c3ref/serialize.html
On Mon, Jul 9, 2018 at 5:52 PM Randall Smith
wrote:
> I'm curious if there is some standard or normal way to convert a SQLite DB
> to a text representation, and then recreate the DB
I'm curious if there is some standard or normal way to convert a SQLite DB to a
text representation, and then recreate the DB content from the text. Naively,
this seems hard or impossible as a general problem, but perhaps I am missing
something.
Thanks in advance for any advice or suggestions.
12 matches
Mail list logo