wxPgSql

Do you like to promote your wxWidgets based application or component!? Post it here and let's see what the critics have to say. Also, if you found that ONE wx component the world needs to know about, put it here for future reference.
vlad
In need of some credit
In need of some credit
Posts: 6
Joined: Fri Oct 22, 2004 8:30 am
Contact:

wxPgSql

Post by vlad » Wed Jan 26, 2005 8:51 pm

I am write wxPgSql library for accessing to PostgreSQL database. It is alpha.
Please see it.

http://vlad.org.ua/wx/

Simple code like:

Code: Select all

wxPgDb db;
db.Connect("host=localhost user=vlad dbname=test password=pass");
if ( db.ConnectionBad() ){
    wxMessageBox(wxString::Format(_("Can't connect to Database: %s"), db.ErrorMessage() ), _("Error"), wxOK|wxICON_ERROR);
    return false;
}
wxPgResult r = db.Exec("SELECT * FROM table WHERE login = CURRENT_USER");
if ( r.IsTuplesOk()  ){
  while ( r.Next() ){
     long l_long;
     wxString str = r.GetValue("some_column");
     r.GetValue("id").ToLong(&l_long);
   }
} else {
  wxMessageBox(_("Query fail"), _("Error"), wxOK| wxICON_ERROR );
};
r.Close();
db.Close();
libpq.dll is required
tested only on wxMSW

User avatar
T-Rex
Moderator
Moderator
Posts: 1188
Joined: Sat Oct 23, 2004 9:58 am
Location: Zaporizhzhya, Ukraine
Contact:

Post by T-Rex » Wed Jan 26, 2005 10:20 pm

Чел, я тут начал писать фрэймворк для MySQL. Могу поделиться.
(а ты откуда вобще)

Jorg
Moderator
Moderator
Posts: 3971
Joined: Fri Aug 27, 2004 9:38 pm
Location: Delft, Netherlands
Contact:

Post by Jorg » Thu Jan 27, 2005 7:55 am

Please talk in English here. It is more polite against everybody else.

- Jorgen
Forensic Software Engineer
Netherlands Forensic Insitute
http://english.forensischinstituut.nl/
-------------------------------------
Jorg's WasteBucket
http://www.xs4all.nl/~jorgb/wb

vlad
In need of some credit
In need of some credit
Posts: 6
Joined: Fri Oct 22, 2004 8:30 am
Contact:

Post by vlad » Thu Jan 27, 2005 8:01 am

I am from Crimea, Ukraine.
Yes, i am want to see your Mysql framework

User avatar
T-Rex
Moderator
Moderator
Posts: 1188
Joined: Sat Oct 23, 2004 9:58 am
Location: Zaporizhzhya, Ukraine
Contact:

Post by T-Rex » Thu Jan 27, 2005 5:52 pm

Respect, man! I'm from Zaporizhzhya, Ukraine.
Add e-mail address to your profile and then I'll send it.
PgSql - is it Postgre SQL (and I'd like to know, can I use this SQL server under Win32, or is it only a client part).

vlad
In need of some credit
In need of some credit
Posts: 6
Joined: Fri Oct 22, 2004 8:30 am
Contact:

Post by vlad » Thu Jan 27, 2005 8:42 pm

Respect to you! Zaporizhzhya is beautiful city!
I am already have email in profile.
Yes, you can!
I am use PostgreSQL 8.0RC-Win32 for my project - perfectly!

IMHO PostgreSQL is better than MySQL.
I am use PostgreSQL for medium and large projects, and SQLite for small and medium projects.

User avatar
T-Rex
Moderator
Moderator
Posts: 1188
Joined: Sat Oct 23, 2004 9:58 am
Location: Zaporizhzhya, Ukraine
Contact:

Post by T-Rex » Thu Jan 27, 2005 10:05 pm

I can see only your ICQ number. (look to the bottom of your posts) 8)

ConnorMacLeod
Knows some wx things
Knows some wx things
Posts: 39
Joined: Thu Nov 25, 2004 10:10 am
Location: Germany

Post by ConnorMacLeod » Fri Jan 28, 2005 8:47 am

T-Rex wrote:(and I'd like to know, can I use this SQL server under Win32, or is it only a client part).
The new version of PostgreSQL comes as a stand alone server under Win32 (no more SygWin is needed.).

And i agree with vlad: it's more powerful than MySQL.

Cheers
Connor
[wxMSW 2.6.1/VC7.1 .NET 2003/WinXP]

buildere
Super wx Problem Solver
Super wx Problem Solver
Posts: 358
Joined: Thu Oct 28, 2004 3:45 pm
Location: Costa Rica

Re: wxPgSql

Post by buildere » Fri Jan 28, 2005 7:55 pm

vlad wrote:I am write wxPgSql library for accessing to PostgreSQL database. It is alpha.
Please see it.

http://vlad.org.ua/wx/
Cool! What platforms does it support?

vlad
In need of some credit
In need of some credit
Posts: 6
Joined: Fri Oct 22, 2004 8:30 am
Contact:

Re: wxPgSql

Post by vlad » Fri Jan 28, 2005 10:51 pm

buildere wrote: Cool! What platforms does it support?
Win32: tested ( medium size project (~20k lines) worked on it)
Linux: partially tested

Suggestions ?

tbreina
Moderator
Moderator
Posts: 1289
Joined: Thu Nov 25, 2004 7:38 pm
Location: Coronado, CA

libpqxx

Post by tbreina » Mon Jan 31, 2005 7:19 pm


buildere
Super wx Problem Solver
Super wx Problem Solver
Posts: 358
Joined: Thu Oct 28, 2004 3:45 pm
Location: Costa Rica

Re: wxPgSql

Post by buildere » Mon Jan 31, 2005 10:27 pm

vlad wrote: Suggestions ?
I think you may have a look at the sources of http://www.pgadmin.org/", cause they made this client using wxWidgets, and it uses libpq or libpqxx. It supports FreeBSD and soon OSX and Solaris.

buildere
Super wx Problem Solver
Super wx Problem Solver
Posts: 358
Joined: Thu Oct 28, 2004 3:45 pm
Location: Costa Rica

libpq and wxWidgets

Post by buildere » Mon Jun 20, 2005 9:22 pm

I just want to point out that pgAdminIII now supports OSX.
http://www.postgresql.org/about/news.342
Again, I encourage vlad to take a look into their sources. It look's like they have written a very good interface for access postgres trough different OS'es, and using wxWidgets at the same time. Maybe this can be translated to a wx library somehow (if the "artistic lisence permits so"). If vlad and T-Rex improve their wxPgSQL and wxMySQL API's I can add a wrapper component for wxDevCpp ala delphi's dbExpress and the like...

User avatar
T-Rex
Moderator
Moderator
Posts: 1188
Joined: Sat Oct 23, 2004 9:58 am
Location: Zaporizhzhya, Ukraine
Contact:

Post by T-Rex » Mon Jun 20, 2005 9:28 pm

Just wait a little bit :) I have to pass the exams at the university and after that I'll increase the functionality of wxMySQL as fast as it possible :)

buildere
Super wx Problem Solver
Super wx Problem Solver
Posts: 358
Joined: Thu Oct 28, 2004 3:45 pm
Location: Costa Rica

Post by buildere » Mon Jun 20, 2005 10:45 pm

Don't worry. I'm on a busy time myself too. :wink:

Post Reply