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
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
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.
that with SQLite?
--
View this message in context:
http://www.nabble.com/SQLite%3A-Porting-to-another-Operating-system.-tp24640206p24648140.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
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
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
you know where's there's documentation
on this?
--
View this message in context:
http://www.nabble.com/SQLite%3A-Porting-to-another-Operating-system.-tp24640206p24644244.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users
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
application
to see it?
--
View this message in context:
http://www.nabble.com/SQLite%3A-Porting-to-another-Operating-system.-tp24640206p24643787.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
. Is there any doc that offers guidelines for successfully porting
SQLite to another operating system.
Regards,
chandan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
11 matches
Mail list logo