Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2013-06-12
1
Medium Priority
?
437 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 1500 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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…
Introduction This article is designed to assist GIS (Geographic Information System) and GPS (Global Positioning System) developers using ESRI ArcGIS and other spatial information management systems.   For the uninitiated the concept of projectio…
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…
Suggested Courses

886 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