...which has reference #14 has Sen listed as the author of another article (can't find direct link), here's #14 though:
Sen, C. K. & Ghatak, S. miRNA control of tissue repair and regeneration. Am. J. Pathol. 185, 2629–2640 (2015).
I wish I could have said this myself. I feel there is a strong desire to get these issues out in the open and deal with this situation. Sadly, no moves are being made by those capable of doing so. If I can help in any way I would gladly do so.
We're actually working on mapping right now for a potential product so it might be possible to add something cool to Postage but I don't know what it would look like. Anything in particular you'd like to see?
Not OP, but I'd be cool to be able to view the results of a query on a map. For instance, if we did `SELECT * FROM points WHERE created < '2016-07-30'` and Postage detected a spatial column, show the returned geometries on a map (using leaflet.js or something similar, perhaps?).
Hmm. I don't know. I think we'd need to show them in relationship to some map, like google or bing for it to make any sense though right? Would there be a legal way to do that? Or am I wrong?
I work in this sector - best and simplest use-case is to run your own OSM basemap and satellite tiles and fetch them on the client using Leaflet, embedding them in your application and rendering the data on top of it.
You'd only probably want to support one or two projections out of the box (EPSG 4326 and 3857, the respective geographic and projected coordinate systems that pretty much are the de-facto standard in GIS). The end-user would have to use PostGIS spatial query to project the data if they wanted to see it on map.
Then you would retrieve the extent (bounding box) of the data from the query, send that to your server, fetch the tiles, and have the Leaflet client render basemap under the data. You could look into https://github.com/lukasmartinelli/osm-liberty for some inspiration of self-hosted OSM.
For street level detail you could look at using OpenStreetMap. The main requirement there is attribution. But it's a massive amount of data and while there are free services, they do have load limits.
For a less detailed backdrop you could look at Natural Earth. For example, it has inner divisions of countries (so states and the like) in about 15 megabytes:
OpenStreetMap could be a good source of a base map with a very liberal licencing issue, You'd only need to have a "Map Data (c) OSM contributors" on the map (IIRC).
The main openstreetmap.org tile servers are liable to block your application if you put too much load on it, but there are plenty of companies which will sell you tile server access, (GeoFabrik, ThunderForest, Mapbox, Mapzen).
Yeah, context would be useful. Perhaps default to some OSM layers (as others have said, the licensing is liberal), but allow the specification of custom tile-servers in the config for Postage (taking the form of a URL with placeholders for lat, lon and zoom).
We stand by the README wording because we've gotten a lot of feedback from users who are not developers. There are additional README documents for developers.
Microsoft Windows 10 Pro
Version 10.0.14393 Build 14393(latest)
uninstalled Postage
removed the following folders:
C:\Users\jtocci\.postage
C:\Users\jtocci\AppData\Roaming\Postage
C:\Program Files (x86)\Workflow Products
Downloaded Postage.Windows.3.2.16.zip
tried to install by double-click. nothing happened. (known Electron issue)
right click to run as administrator
install for all users, default location
Postage popped right up. Any ideas how I can get the error you're getting?
The main reason we haven't done this is because we had hoped to get Postage renamed PGAdmin5. Unfortunately, that outcome seems ever more unlikely. There seems to be some political reason why the PGA4 team continues to get official support while in ongoing trainwreck mode for a year now.
justintocci left another comment, which he has since deleted, but since I've spent some time investing in an answer, I'm posting it here. Justin, if you dislike being quoted, let me know.
> In fact, it really should have had these tools a decade ago.
What does "should" mean here? That it'd have been good? Sure. That people working (as a hobby, or as part of their employment) on PG should have stopped doing what they were, and instead focus on doing tooling? Maybe, but given the very very limited number of people and their skills I doubt it'd have been a good trade.
> So I propose a better question. Why doesn't PostgreSQL have free, enterprise-grade tools?
I think there's plenty of reasons, and everyone will weigh them differently:
For one, the development community is actually surprisingly small, especially a couple years back; only in the last few years that's changed to some degree. Which means we're often struggling to get the crucially needed server features done, not to speak of delving into a bunch of features outside of our expertise.
Another big reason, and that might sound counterintuitive, is PostgreSQL's license. Because of it and the long community support cycles, companies around PG have a hard time making money w/ licensing etc. So they have to focus on support, training and value-adds. A number companies tried / try to make money selling software around postgres, more enterprise-y tooling among that. Often that doesn't turn out to work that well, because it's actually a lot of work, and without input from the larger community they don't get the necessary market penetration.
Thirdly, I think that PG's development is done by a number of different companies, with each company's share of development not being large enough to sustain the project, explains some of this. I think it's overall an advantage, but in some areas like coordinated planning, marketing and coordinated effort it has its downsides too. If you want to make value-add software around core you're not going to do so with a competitor.
Lastly, I think for a long time Pgadmin3 was seen as not being good, but kinda somewhat acceptable. But its implementation wasn't particularly clean, in a language relatively few GUI folks use (C++), using a dying and buggy GUI framework (wxwidgets). I think it was for a long time just good enough that MVP of something better wasn't all that minimal anymore.
I actually left two comments and deleted them both. It's very difficult to say these things from my position but I like everything you said a lot. If I had said them my obvious bias would have detracted from it. From my position it's just best if I keep my mouth shut, but these are important issues and I think very much in need of attention.
