Solved

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

Posted on 2013-06-12
1
414 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
Comment Utility
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

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,…
Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
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…

772 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

16 Experts available now in Live!

Get 1:1 Help Now