|Subject:||Re: Am I missing something?
|Date:||Wed, 17 Jun 2020 11:33:59 +1000
|From:||Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
I have an address lookup and mapping function in my application and the
address lookup needs the Australian geocoded address database. Just
converting the csv files to SQL Express blew out the database size. So I
reduced it and made 2 databases. Fine. Unless you want to access the 2
databases at the same time. Not with express you don't.
In any case, PostGIS (the GIS add-in to Postgres) is a wondrous thing.
No more tedious calculations of mapping data and having to remember the
circumference of the earth in metres, just call a built in function.
Courses for horses. If your database needs fit into 10 gigs and you only
need one at a time, SQL Express is perfectly adequate. And it fits
seamlessly into VS.
On 16/06/2020 12:22 pm, Kevin Zawicki wrote:
> Seem to be 10 GB and you can have more than 1 DB.
> At least I can start porting over some things.