Menu
▾
▴
sql-ledger-users
|
From: Ilkka . <gon...@ho...> - 2001-10-22 20:35:42
|
I think this would not be that convienient, because the information in those databases are connected to each other. It's a web shop.. >From: "Rod Roark" <ro...@su...> >To: <sql...@li...> >Subject: Re: MySQL and sql-ledger? >Date: Mon, 22 Oct 2001 13:26:14 -0700 (PDT) > >There's nothing to prevent you from running MySQL and PostgreSQL >concurrently. It would be a lot easier than hacking the code. > >Cheers, > >-- Rod > http://www.sunsetsystems.com/ > >Ilkka . said: > > Hi! > > > > My problem is that I really need to make to sql-ledger work with MySQL. >Not because > > MySQl would be better (probably it isn't) but because my other software >use MySQL, > > and I don't want to change those. > > > > So, it would be great if womeone would write a brief list to point out >things and > > files that should be modified. I guess Perl is not that big a problem, >but that list > > would help a lot this searching-debugging-testing process. > > > > Thanks, > > Ilkka > > > > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp |
|
From: Ilkka . <gon...@ho...> - 2001-10-22 22:08:01
|
It seems that I will write my code to use any SQL database through ODBC and let Sql-ledger use PostgreSQL. Thanks for the input..helped to make this decision. Sql-ledger using ODBC would be too cool though :) >From: Dieter Simader <dsi...@sq...> >To: "Ilkka ." <gon...@ho...> >CC: sql...@li... >Subject: Re: MySQL and sql-ledger? >Date: Mon, 22 Oct 2001 15:17:59 -0600 (MDT) > >Make a list of what you actually need to have available for your webshop. >Then decide how to go about tying in with SL or vice versa. > >If you just need to have current pricing information available at the >webshop you can easily hack in another DBI connection to simultaneously >update mySQL or go from the other side and update the SL tables from your >webshop. > > >Dieter Simader http://www.sql-ledger.org (780) 472-8161 >DWS Systems Inc. Accounting Software Fax: 478-5281 >=========== On a clear disk you can seek forever =========== > >On Mon, 22 Oct 2001, Ilkka . wrote: > > > > > I think this would not be that convienient, because the information in >those > > databases are connected to each other. It's a web shop.. > > > > >From: "Rod Roark" <ro...@su...> > > >To: <sql...@li...> > > >Subject: Re: MySQL and sql-ledger? > > >Date: Mon, 22 Oct 2001 13:26:14 -0700 (PDT) > > > > > >There's nothing to prevent you from running MySQL and PostgreSQL > > >concurrently. It would be a lot easier than hacking the code. > > > > > >Cheers, > > > > > >-- Rod > > > http://www.sunsetsystems.com/ > > > > > >Ilkka . said: > > > > Hi! > > > > > > > > My problem is that I really need to make to sql-ledger work with >MySQL. > > >Not because > > > > MySQl would be better (probably it isn't) but because my other >software > > >use MySQL, > > > > and I don't want to change those. > > > > > > > > So, it would be great if womeone would write a brief list to point >out > > >things and > > > > files that should be modified. I guess Perl is not that big a >problem, > > >but that list > > > > would help a lot this searching-debugging-testing process. > > > > > > > > Thanks, > > > > Ilkka > > > > > > > > > > > > > > > > > > _________________________________________________________________ > > Get your FREE download of MSN Explorer at >http://explorer.msn.com/intl.asp > > > > > > > > > > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp |
|
From: Tommie M. J. <tj...@at...> - 2001-10-22 22:32:05
|
How do I unsubscribe to this list. I've tried going here https://lists.sourceforge.net/lists/listinfo/sql-ledger-users to 'edit options' but I get a broken link. http://www.atlantageek.com Get inside Atlanta's Tech scene |
|
From: Ilkka . <gon...@ho...> - 2001-10-24 19:37:14
|
Actually I'm back to square one, and even a bit farther than that. I just noticed that PostgreSQL server doesn't work with Win98. Oh well. I think I'll just start hacking Sql-ledger again. Somebody had mentioned a success, and it doesn't sound that impossible thing to do...(famous last words?). Ilkka >From: Dieter Simader <dsi...@sq...> >To: "Ilkka ." <gon...@ho...> >CC: sql...@li... >Subject: Re: MySQL and sql-ledger? >Date: Mon, 22 Oct 2001 15:17:59 -0600 (MDT) > >Make a list of what you actually need to have available for your webshop. >Then decide how to go about tying in with SL or vice versa. > >If you just need to have current pricing information available at the >webshop you can easily hack in another DBI connection to simultaneously >update mySQL or go from the other side and update the SL tables from your >webshop. > > >Dieter Simader http://www.sql-ledger.org (780) 472-8161 >DWS Systems Inc. Accounting Software Fax: 478-5281 >=========== On a clear disk you can seek forever =========== > >On Mon, 22 Oct 2001, Ilkka . wrote: > > > > > I think this would not be that convienient, because the information in >those > > databases are connected to each other. It's a web shop.. > > > > >From: "Rod Roark" <ro...@su...> > > >To: <sql...@li...> > > >Subject: Re: MySQL and sql-ledger? > > >Date: Mon, 22 Oct 2001 13:26:14 -0700 (PDT) > > > > > >There's nothing to prevent you from running MySQL and PostgreSQL > > >concurrently. It would be a lot easier than hacking the code. > > > > > >Cheers, > > > > > >-- Rod > > > http://www.sunsetsystems.com/ > > > > > >Ilkka . said: > > > > Hi! > > > > > > > > My problem is that I really need to make to sql-ledger work with >MySQL. > > >Not because > > > > MySQl would be better (probably it isn't) but because my other >software > > >use MySQL, > > > > and I don't want to change those. > > > > > > > > So, it would be great if womeone would write a brief list to point >out > > >things and > > > > files that should be modified. I guess Perl is not that big a >problem, > > >but that list > > > > would help a lot this searching-debugging-testing process. > > > > > > > > Thanks, > > > > Ilkka > > > > > > > > > > > > > > > > > > _________________________________________________________________ > > Get your FREE download of MSN Explorer at >http://explorer.msn.com/intl.asp > > > > > > > > > > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp |
|
From: <gha...@fr...> - 2001-10-24 20:07:10
|
On Wed, 24 Oct 2001, Ilkka . wrote: > Actually I'm back to square one, and even a bit farther than that. I just > noticed that PostgreSQL server doesn't work with Win98. Oh well. It doesn't work with Win98, or on Win98? The machine running Apache and SQL-Ledger doesn't have to be the machine running PostgreSQL. I have a picture library here which uses one machine for the web server part, and another machine for PostgreSQL to store names, descriptions, etc. |
|
From: Rod R. <ro...@su...> - 2001-10-22 21:06:46
|
Well obviously you have about 3 different ways to approach the problem: (1) rewrite sql-
ledger, (2) rewrite your mysql apps, or (3) write code that talks to both. For what it's
worth the following is from the FAQ:
"Although transactions are now supported with the InnoDB
table handler the backend would still require a major
rewrite to work with mySQL"
But maybe it's not that bad... best of luck...
-- Rod
http://www.sunsetsystems.com/
Ilkka . said:
>
> I think this would not be that convienient, because the information in those
> databases are connected to each other. It's a web shop..
>
>>From: "Rod Roark" <ro...@su...>
>>To: <sql...@li...>
>>Subject: Re: MySQL and sql-ledger?
>>Date: Mon, 22 Oct 2001 13:26:14 -0700 (PDT)
>>
>>There's nothing to prevent you from running MySQL and PostgreSQL
>>concurrently. It would be a lot easier than hacking the code.
>>
>>Cheers,
>>
>>-- Rod
>> http://www.sunsetsystems.com/
>>
>>Ilkka . said:
>> > Hi!
>> >
>> > My problem is that I really need to make to sql-ledger work with MySQL.
>>Not because
>> > MySQl would be better (probably it isn't) but because my other software
>>use MySQL,
>> > and I don't want to change those.
>> >
>> > So, it would be great if womeone would write a brief list to point out
>>things and
>> > files that should be modified. I guess Perl is not that big a problem,
>>but that list
>> > would help a lot this searching-debugging-testing process.
>> >
>> > Thanks,
>> > Ilkka
|
|
From: Dieter S. <dsi...@sq...> - 2001-10-22 21:18:08
|
Make a list of what you actually need to have available for your webshop. Then decide how to go about tying in with SL or vice versa. If you just need to have current pricing information available at the webshop you can easily hack in another DBI connection to simultaneously update mySQL or go from the other side and update the SL tables from your webshop. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Mon, 22 Oct 2001, Ilkka . wrote: > > I think this would not be that convienient, because the information in those > databases are connected to each other. It's a web shop.. > > >From: "Rod Roark" <ro...@su...> > >To: <sql...@li...> > >Subject: Re: MySQL and sql-ledger? > >Date: Mon, 22 Oct 2001 13:26:14 -0700 (PDT) > > > >There's nothing to prevent you from running MySQL and PostgreSQL > >concurrently. It would be a lot easier than hacking the code. > > > >Cheers, > > > >-- Rod > > http://www.sunsetsystems.com/ > > > >Ilkka . said: > > > Hi! > > > > > > My problem is that I really need to make to sql-ledger work with MySQL. > >Not because > > > MySQl would be better (probably it isn't) but because my other software > >use MySQL, > > > and I don't want to change those. > > > > > > So, it would be great if womeone would write a brief list to point out > >things and > > > files that should be modified. I guess Perl is not that big a problem, > >but that list > > > would help a lot this searching-debugging-testing process. > > > > > > Thanks, > > > Ilkka > > > > > > > > > > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > > > |
Thanks for helping keep SourceForge clean.
X