[OpenLayers-Users] which is the best way to display a set of points coming from database?

[Alberto Valente]

dear BMcBride and RFeagin,
If you send me your works I'll give them a try!!
Actually I've managed creating a geojson object from the php page that
executes the query.
The geojson featurecollection is echoed inside the main page so I have it
inside the openlayers <script></script>
I know it's not a optimum solution but actually it works and I can show it
to the boss! So now I'm keeping it and I'll improve it in the future.

if you want on next monday I can send or post here the solution I've found
but, since I know it's horrible, you have to promise me you won't laugh at
it ;-)

thank you

alberto

On Wed, Sep 1, 2010 at 5:05 PM, RFeagin <
ryan.feagin at peachtreegeographics.com> wrote:

>
> I had a need for simply displaying thousands of css styled points from a
> SQL
> Server db (no need for click handlers) and ended up creating a custom tiled
> vector layer.  The points are created as img tags.  I can even swap the
> style sheet on the fly to change thematics without having to post anything
> back.  Carving up the data into the tiles allowed for caching of the point
> data too since the bounding box of each tile is consistent just like with a
> WMS.  On the database side, it returns clustered points with css styles as
> KML.  I never have gotten around to cleaning up the code or getting it to
> be
> generic and to the point where it was worthy of submitting back to the
> community.  I only took it just as far as I needed for what I was doing.
>  If
> someone else could benefit from it and be able to finish it up, I'd of
> course be more than willing to send it.
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/which-is-the-best-way-to-display-a-set-of-points-coming-from-database-tp5482933p5487444.html
> Sent from the OpenLayers Users mailing list archive at Nabble.com.
> _______________________________________________
> Users mailing list
> Users at openlayers.org
> http://openlayers.org/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/openlayers-users/attachments/20100901/28e014ce/attachment.html