Re: [web2py] Which DB is best suited for many single entry to one table ?

Those numbers are easily handled by both databases using commodity hardware, real or virtual. Choose postgresql, it's good choice since it has support for geo spatial data management, while IMHO there is no reason to use mysql. mic 2014-10-06 6:30 GMT+02:00 arutti : > I have a geolocalisation ap

[web2py] Which DB is best suited for many single entry to one table ?

I have a geolocalisation application with 2 tables of interest i.e. db.define_table('device', notnull=True, ...) db.define_table('wp', 'device', type=reference device, notnull=True, ...) The 'device' table may have several hundreds entries, while the 'wp' table holding GPS-coordinates may have t