Thread: Cygwin / Debian dpkg / PostgreSQL / KDE2 and 3
Dear all, I would like to try compile Debian DPKG and APT-GET under Windows. This would allow us to create a modern Windows installer for Cygwin, KDE2/3 and PostgreSQL. There are already existing project at http://debian-cygwin.sourceforge.net/ and http://kde-cygwin.sourceforge.net/. The example of http://fink.sourceforge.net/ for MacOSX is quite interesting because it includes PostgreSQL. The installation method is so much better than Cygwin!!! There is no GUI installer yet, but it will come for sure. IMHO, this would be the best solution complying with the open-source philosophy and goals. Basically, this would provide the framework for : - creating a PostgreSQL + Cygwin modern GUI installer. All required .DEB packages would be downloaded and installed from Debian mirrors, with little user intervention. PostgreSQL would be installed as a service. - a cross-platform GUI environment for (future) pgAdmin. Please note I am not dealing with pgAdmin future. Dave Page thinks Mono is the solution. I don't agree and think we should use Cygwin-KDE or native Windows libraries. Is it safe to compile Cygwin using Dev-C++? Is anyone interested in the project? Mark : as you said you were a Windows code-storm, how much time do you think it would take for someone like you to port DPKD + APT-GET to Windows and create a debian GUI package installer for Cygwin? Cheers, Jean-Michel POURE
On Wed, 8 May 2002, Jean-Michel POURE wrote: > This would allow us to create a modern Windows installer for Cygwin, KDE2/3 > and PostgreSQL. There are already existing project at > http://debian-cygwin.sourceforge.net/ I'm subscribed to debian-win32@lists.debian.org mailing list but do no active development there. (I think it would be sane to ask this question there but I do not like to start cross-posting so I leave it in your hands to post your question there.) If I'm not completely wrong this project had some success in porting dpkg and apt might be available in the not so far future - but I might be wrong. > and http://kde-cygwin.sourceforge.net/. I do not know this project. > IMHO, this would be the best solution complying with the open-source > philosophy and goals. I like this project and I hope it will evolve - but my Win knowledge is nearly zero. > - creating a PostgreSQL + Cygwin modern GUI installer. All required .DEB > packages would be downloaded and installed from Debian mirrors, with little > user intervention. PostgreSQL would be installed as a service. For sure this is the goal. > - a cross-platform GUI environment for (future) pgAdmin. Please note I am not > dealing with pgAdmin future. Dave Page thinks Mono is the solution. I don't > agree and think we should use Cygwin-KDE or native Windows libraries. Or alternatively wxGtk/wxWindows which has more options to choose the programming language if I'm not completely wrong. > Mark : as you said you were a Windows code-storm, how much time do you think > it would take for someone like you to port DPKD + APT-GET to Windows and > create a debian GUI package installer for Cygwin? Please make sure to ask on debian-win32@lists.debian.org before starting an additional project. You can subscribe to this list on the general Debian subscription page http://www.debian.org/MailingLists/subscribe Kind regards and good luck for the project Andreas.
Jean-Michel POURE wrote: > - creating a PostgreSQL + Cygwin modern GUI installer. All required .DEB > packages would be downloaded and installed from Debian mirrors, with little > user intervention. PostgreSQL would be installed as a service. > > - a cross-platform GUI environment for (future) pgAdmin. Please note I am not > dealing with pgAdmin future. Dave Page thinks Mono is the solution. I don't > agree and think we should use Cygwin-KDE or native Windows libraries. This may be a stupid question, but could the new Mozilla be used as a cross-platform GUI? Seems like a natural because it is supposed to be more of a platform with a browser built on top. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
Java is another possibility, since it is already cross platform. Dave On Tue, 2002-06-04 at 01:08, Bruce Momjian wrote: > Jean-Michel POURE wrote: > > - creating a PostgreSQL + Cygwin modern GUI installer. All required .DEB > > packages would be downloaded and installed from Debian mirrors, with little > > user intervention. PostgreSQL would be installed as a service. > > > > - a cross-platform GUI environment for (future) pgAdmin. Please note I am not > > dealing with pgAdmin future. Dave Page thinks Mono is the solution. I don't > > agree and think we should use Cygwin-KDE or native Windows libraries. > > This may be a stupid question, but could the new Mozilla be used as a > cross-platform GUI? Seems like a natural because it is supposed to be > more of a platform with a browser built on top. > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > >
On 4 Jun 2002, Dave Cramer wrote:
> Java is another possibility, since it is already cross platform.
... with certain licensing issues ...
Just a remark
Andreas.
The jdbc driver has a method to return the exported keys from a table,
we require essentially what the following select returns, but it is
slow, can anyone suggest ways to optimize it?
Regards,
Dave
SELECT c.relname as primary, c2.relname as foreign, t.tgconstrname, ic.relname as fkeyname,
af.attnum as fkeyseq, ipc.relname as pkeyname, ap.attnum as pkeyseq, t.tgdeferrable,
t.tginitdeferred, t.tgnargs,t.tgargs, p1.proname as updaterule, p2.proname as deleterule
FROM pg_trigger t, pg_trigger t1, pg_class c, pg_class c2, pg_class ic, pg_class
ipc, pg_proc p1, pg_proc p2, pg_index if, pg_index ip, pg_attribute af, pg_attribute
ap
WHERE (t.tgrelid=c.oid AND t.tgisconstraint AND t.tgconstrrelid=c2.oid AND t.tgfoid=p1.oid
and p1.proname like '%%upd')
and (t1.tgrelid=c.oid and t1.tgisconstraint and t1.tgconstrrelid=c2.oid AND
t1.tgfoid=p2.oid and p2.proname like '%%del')
AND c2.relname='users'
AND (if.indrelid=c.oid AND if.indexrelid=ic.oid and ic.oid=af.attrelid AND
if.indisprimary)
and (ip.indrelid=c2.oid and ip.indexrelid=ipc.oid and ipc.oid=ap.attrelid and
ip.indisprimary)
;