Solved

How to load a raster from in-memory bitmap (not from file) into PostgreSQL

Posted on 2013-06-12
1
423 Views
Last Modified: 2013-07-10
I have a bitmap in memory that I would like to load as a raster to PostgreSQL.

An unfavorable option is saving the bitmap to file and then use raster2pgsql, but as we
have several cameras that produce images at high rate, we can't afford saving them to files just for sake of insertion to the DB.

I'm looking for a solution for loading the bitmap directly from memory. Any suggestions?

I'm using PostgreSQL 9.2 using PostGIS2.0 on Windows 7.
The images are plain gray level, if it matters.
0
Comment
Question by:HPBSM
1 Comment
 
LVL 22

Accepted Solution

by:
earth man2 earned 500 total points
ID: 39249610
http://www.postgresql.org/docs/9.2/static/lo-interfaces.html#LO-CREATE
32.3.5. Writing Data to a Large Object
fd comes from a previous lo_open
int lo_write(PGconn *conn, int fd, const char *buf, size_t len);
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
I feel like more and more people want to know how to programmatically convert addresses into geospatial locations. So in this article, I will show you how you can do it with Bing Maps. I'm going to use PowerShell, which is a nice scripting language,…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question