Solved

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

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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 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…

831 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