Re: [GENERAL] Postgresql Development Options
On Sun, Apr 5, 2015 at 6:46 PM, Steve Atkins wrote: > > On Apr 5, 2015, at 1:21 PM, Ray Madigan wrote: > > > I have been using postgresql in java off and on for many years. I now > have an assignemtn where I have to build a very straight forward networked > application that needs to be able to insert Array data types from a windows > environment to a remote Linux Postgresql database. > > > > My first attempt was to use Qt. Their is a postgresql driver and found > out the hard way that it doesn't support the Array data type. I need a > small ui so the user can set options for the application. My question is, > are there other UI options that I can use to development this application. > > The Qt database driver is not great for general use. Where it shines is > when you want to do simple CRUD queries and to have them connected to > widgets with minimal work. It should support arrays, though, with a little > data transformation. > > If you're looking to use C++ then Qt is an excellent framework for a GUI > app - one that you won't beat for cross-platform work - but you might > consider whether using libpqxx or libpq to connect to the database might > suit your needs better. > > Cheers, > Steve > I tried to use libpq this morning and all it can do is crash. I have Postgresql running on my local machine and have installed the ODBC drivers, not that that matters at this point. I can't seem to get past the call to connect to the database.: my code looks like: PGconn * connection; char conninfo[250]; sprintf(conninfo, "user=%s password=%s dbname=%s hostaddr=%s port=%d", "user", "password", "foo", "192.168.3.3", 5433); qDebug() << "Foo1: " << conninfo; connection = PQconnectdb( conninfo ); qDebug() << "Foo1: "; And I get The program has unexpectedly finished.
Re: [GENERAL] Postgresql Development Options
The application will be very small, its main function is as a data acquision tool that reads data from an c api and does minimal processing and feeds it off to a postgresql database for offline processing. I haven't written the PC side application yet, just a prototype in Qt. It just hast to be as fast as possible, or I would java. I am comfortable with c++, but would use other language if it would get the job done. The ui is used basically to control the device that is generating the data, and parsing it into sql to send to the database. Very simple. Thank you. ps, if I shouldn't include your email in my response tell me, I am not sure what the conventions are. On Sun, Apr 5, 2015 at 1:35 PM, Adrian Klaver wrote: > On 04/05/2015 01:21 PM, Ray Madigan wrote: > >> I have been using postgresql in java off and on for many years. I now >> have an assignemtn where I have to build a very straight forward >> networked application that needs to be able to insert Array data types >> from a windows environment to a remote Linux Postgresql database. >> >> My first attempt was to use Qt. Their is a postgresql driver and found >> out the hard way that it doesn't support the Array data type. I need a >> small ui so the user can set options for the application. My question >> is, are there other UI options that I can use to development this >> application. >> > > What languages are you comfortable with? > > Seems from the above the UI is separate from the application, is that the > case? > > Is so what is the application written in? > > >> Thanks in advance. >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
[GENERAL] Postgresql Development Options
I have been using postgresql in java off and on for many years. I now have an assignemtn where I have to build a very straight forward networked application that needs to be able to insert Array data types from a windows environment to a remote Linux Postgresql database. My first attempt was to use Qt. Their is a postgresql driver and found out the hard way that it doesn't support the Array data type. I need a small ui so the user can set options for the application. My question is, are there other UI options that I can use to development this application. Thanks in advance.
