On Jul 24, 2009, at 8:44 AM, D. Richard Hipp wrote:
> SQLite database files are cross-platform. All you have to do is copy
> the file to the new machine. There is no separate "external format".
> The same database file format work on all platforms.
Just make sure that if you are moving to a new
Re: "I can't see how you get to that page."
I found the link from page:
http://www.sqlite.org/features.html
And perhaps it's linked from others as well.
Re: "I would expect to reorganise the physical database on a regular
basis..."
Once again, I'd look at the VACUUM command, though you
On Fri, 24 Jul 2009, CityDev wrote:
> I'm only familiar with DB2, Access Jet and Focus. In each case I would
> expect to reorganise the physical database on a regular basis - maybe
> daily or weekly. What's the best way of doing that with SQLite?
Vacuum.
Rich
--
Richard B. Shepard, Ph.D.
Thanks Donald. I can't see how you get to that page off the documentation
menu but now I can go direct.
I'm only familiar with DB2, Access Jet and Focus. In each case I would
expect to reorganise the physical database on a regular basis - maybe daily
or weekly. What's the best way of doing that w
On 24 Jul 2009, at 2:09pm, CityDev wrote:
> All you have to do is copy
>
> That's handy - I didn't realise that. However I suggest it's good
> practice
> to dump and reload in these kinds of situations. I don't yet know
> how SQLite
> works but I suspect a reload will get the physical data i
Hi, CityDev,
Regarding:
All you have to do is copy
That's handy - I didn't realise that. However I suggest it's good
practice to dump and reload in these kinds of situations. I don't yet
know how SQLite works but I suspect a reload will get the physical data
into a better shape and clear out
D. Richard Hipp wrote:
> On Jul 24, 2009, at 8:37 AM, CityDev wrote:
>
>
>> I'm new to SQLite. I would assume you would dump the tables to an
>> external
>> format and then load them into the new database. I can't however see
>> where
>> the documentation is for this kind of database managem
All you have to do is copy
That's handy - I didn't realise that. However I suggest it's good practice
to dump and reload in these kinds of situations. I don't yet know how SQLite
works but I suspect a reload will get the physical data into a better shape
and clear out deleted items etc. Do yo
On Jul 24, 2009, at 8:37 AM, CityDev wrote:
>
> I'm new to SQLite. I would assume you would dump the tables to an
> external
> format and then load them into the new database. I can't however see
> where
> the documentation is for this kind of database management function.
> Anyone
> know w
I'm new to SQLite. I would assume you would dump the tables to an external
format and then load them into the new database. I can't however see where
the documentation is for this kind of database management function. Anyone
know where I should look, or do you have to download the SQLite3 applicat
10 matches
Mail list logo
