Looking at it from a TRA (Threat Risk Assessment) point of view
OpenStreetMap is not totally dependent on one central database being up
and working.
The primary database is fed by edits but if the database happens to get
encrypted by Malware the backup and copies are still there. The tiles
And database size limit is just a start :)
It is artificially limited to 1G of RAM. I am curious how long planet import
with 1GB of RAM would run :)
Jul 25, 2020, 13:31 by jwhelan0...@gmail.com:
> And as we start to fill the database with buildings even those might not fit.
>
> Thanks John
>
>
And as we start to fill the database with buildings even those might not
fit.
Thanks John
On Sat, Jul 25, 2020, 05:19 Hartmut Holzgraefe wrote:
> On 24.07.20 23:55, john whelan wrote:
> > Microsoft SQL Server Express is a free limited version of SQL server
> > that may well do for many users.
On 24.07.20 23:55, john whelan wrote:
Microsoft SQL Server Express is a free limited version of SQL server
that may well do for many users.
reading express edition limitations I see:
* Maximum relational database size: 10GB
That would only be enough for the smallest of OSM regional extracts
2020-07-25, št, 00:58 john whelan rašė:
> If reliability and security are critical then you have to start balancing
> things out.
This is a lie or FUD. Microsofts security/reliability level was a
joke 20-30 years ago, it got somehow better since then but security is
nowhere close and the tools
Holzgraefe
Samrit: talk@openstreetmap.org Efni: Re: [OSM-talk] Heresy -
pure discussion Thank you Hartmut,
my expertise is not in GIS databases so this is helpful to know. My
experience is much more to do with straight SQL databases doing none GIS
work on a variety of platforms.
Cheerio John
POSTGRESQL with Gis extension has better performance than SQL Server
indexing coordinates/type(node, way, polygon, relation) as columns.
On Fri., Jul. 24, 2020, 7:01 p.m. John Whelan,
wrote:
> Thank you Hartmut,
>
> my expertise is not in GIS databases so this is helpful to know. My
>
Thank you Hartmut,
my expertise is not in GIS databases so this is helpful to know. My
experience is much more to do with straight SQL databases doing none GIS
work on a variety of platforms.
Cheerio John
Hartmut Holzgraefe wrote on 2020-07-24 18:49:
On 25.07.20 00:16, Alexandre Oliveira
On 25.07.20 00:16, Alexandre Oliveira wrote:
Having said that the main advantage of SQL is
it is a standard so you should be able to connect practically anything to
it.
That's not entirely true. SQL is a language but every database
implements its own dialect, i.e., some query keywords
I think it's stupid to even think about switching to MSSQL. OSM is
free and open data built on top of free and open source technologies.
Switching to MSSQL would be a dumb move, and as mentioned before, it
would require the refactor of several tools built to work with
PostgreSQL, which is pretty
You need to define the requirements and if having open source software is a
top priority that's fine.
If reliability and security are critical then you have to start balancing
things out.
In general UNIX based solutions do not have the same tools available in
Windows but with a skilled
But face it, philosophy is now also part of the discussion. And that's
important.
Yves
Le 24 juillet 2020 20:50:22 GMT+02:00, john whelan a
écrit :
>If the database was smaller and less infrastructure was reliant on it
>working I would agree with you that philosophically open source software
Note: I am not a sysadmin. But overall I am missing any decent reasons to make
such move.
Maybe there is some reason for that, but nothing from what you presented
appears to be
a good reason.
Frankly, if company had major problem with production severs using default
passwords,
uncontrolled
2020-07-24, pn, 21:14 john whelan rašė:
> I think we either run the largest PostgreSQL database there is or it is close
> to it.
Why do you think so? To my knowledge there are mch larger
PostgreSQL databases going into petabytes.
Can you be more specific as to what exactly was better in
If the database was smaller and less infrastructure was reliant on it
working I would agree with you that philosophically open source software
makes a lot of sense.
However your argument is philosophical rather than logical.
Note I'm merely requesting that the idea be examined. I am not saying
You're probably have some very good points when it comes to database
management, but running an open map on open source software makes a lot of
sense.
Yves
Le 24 juillet 2020 20:11:46 GMT+02:00, john whelan a
écrit :
>All this talk about databases and servers and sysadmins makes me wonder
All this talk about databases and servers and sysadmins makes me wonder if
we should reconsider our choice of operating systems and databases.
At one time in the past I ran a Database support group that covered Sybase,
Oracle, Microsoft SQL server, ingres and half a dozen other database
systems.
17 matches
Mail list logo
