Randall wrote:
~
~
> Any application that involves a "persistent" database, i.e., one where
the data is
> long-lived and expected to exist and evolve over time, sooner or later
has the issue
> of moving customers from a V1 database to a V2 database. Obviously at
least one
> technical issue (there
> This is not strictly a SQLite question, though in my case it is.
>
> Any application that involves a "persistent" database, i.e., one where the
> data is long-lived and expected to exist and evolve over time, sooner or later
> has the issue of moving customers from a V1 database to a V2
pated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Roger Binns
>Sent: Thursday, 30 August, 2018 11:10
>To: sqlite-users@mailinglists.sqlite.org
>Subject: Re: [sqlite] Best practices for forward conversio
On Thu, Aug 30, 2018 at 11:10 AM Roger Binns wrote:
>
> On 30/08/18 09:51, Randall Smith wrote:
> > is how to convert existing data from one DB format to another, given some
> > arbitrary set of changes in the database schema in the interim.
>
> I use SQLite's user pragma. It starts at zero.
>
On 30 Aug 2018, at 5:51pm, Randall Smith wrote:
> Are there accepted or best practices in the industry for handling this in
> general, or with SQLite in particular? Can anyone who has implemented this
> make useful suggestions? Or are there published resources I am missing?
Roger has
On 30/08/18 09:51, Randall Smith wrote:
> is how to convert existing data from one DB format to another, given some
> arbitrary set of changes in the database schema in the interim.
I use SQLite's user pragma. It starts at zero.
https://sqlite.org/pragma.html#pragma_user_version
My code ends
This is not strictly a SQLite question, though in my case it is.
Any application that involves a "persistent" database, i.e., one where the data
is long-lived and expected to exist and evolve over time, sooner or later has
the issue of moving customers from a V1 database to a V2 database.
7 matches
Mail list logo
