Solved

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

Posted on 2013-06-12
1
420 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
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…
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now