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
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
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
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
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
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
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
.dump in the command line shell?
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Randall Smith
>Sent:
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
10 matches
Mail list logo