Comments (6)
Hi @bchapuis ,
Let's share with you this excellent SQL parser : https://github.com/JSQLParser/JSqlParser
Cheers
from incubator-baremaps.
@ebocher Thanks a lot for the pointer and the interesting discussion, this is definitely a solid candidate to replace my poorman's parser, especially if the Postgresql syntax is well supported.
from incubator-baremaps.
It will be a pleasure to share experience, feedback and go ahead with you and the Suisse team ;-)
from incubator-baremaps.
@ebocher I just gave a try to the parser and one of my use cases involves a feature which will be released in 4.1. Basically, it is not yet possible to parse this kind of queries with JSQLParser.
"SELECT id, hstore(array['tag1', 'tag2'], array[tag1, tag2]), geom FROM table"
But so far, the experience with this library is pretty good and it may help at optimizing the queries further.
from incubator-baremaps.
Nice and it seems there is a release in the pipe JSQLParser/JSqlParser#1231
from incubator-baremaps.
Yes, that's great, I just have to be patient.
from incubator-baremaps.
Related Issues (20)
- Release Baremaps v0.7.2
- Fix antialias artifacts at low zoom level
- Remove the APPENDIX section in the Licence
- Geocoder based on OpenStreetMap data
- Print offending query or file when there's a PostgreSQL exception HOT 1
- Workflow processing does not permit Postgres DO / Function blocks HOT 4
- Generated tileset.json doesn't include `queries` key for each layer HOT 11
- Store binary versions for all releases HOT 4
- Improve exception handling and logging in baremaps HOT 1
- How to fetch env variables in style.js/tileset.js HOT 2
- Set number of event loop threads HOT 6
- Basic read OSM PBF Node/Way elements into an Lucene index.
- Include the version number in the license of the binary distribution
- Filter the OSM entities by bounding box and tags when importing data HOT 1
- Questions about source release artifact HOT 2
- java.nio.file.FileAlreadyExistsException on file unzip HOT 6
- CGAlgorithmsDD::orientationIndex encountered NaN/Inf numbers HOT 5
- [Cache] Question HOT 1
- SQL Join Erreur HOT 5
- Replace the osm files by osm-testdata HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from incubator-baremaps.