[Vtigercrm-developers] Build a vTiger Bounty Team
Brian Laughlin
brian at pr2k.com
Thu Feb 23 23:50:55 PST 2006
I was wondering if I could get some type of "sponsorship" officially
from vTiger and allow myself and the newly created team to have a title
that would give us some sense of belonging. I kind of think that I'm
out of place leading this movement without some sense of being official.
Regards,
Brian Laughlin
-----Original Message-----
From: vtigercrm-developers-bounces at lists.vtigercrm.com
[mailto:vtigercrm-developers-bounces at lists.vtigercrm.com] On Behalf Of
vtigercrm-developers-request at lists.vtigercrm.com
Sent: Wednesday, February 22, 2006 10:28 PM
To: vtigercrm-developers at lists.vtigercrm.com
Subject: vtigercrm-developers Digest, Vol 2, Issue 49
Send vtigercrm-developers mailing list submissions to
vtigercrm-developers at lists.vtigercrm.com
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.vtigercrm.com/mailman/listinfo/vtigercrm-developers
or, via email, send a message with subject or body 'help' to
vtigercrm-developers-request at lists.vtigercrm.com
You can reach the person managing the list at
vtigercrm-developers-owner at lists.vtigercrm.com
When replying, please edit your Subject line so it is more specific than
"Re: Contents of vtigercrm-developers digest..."
Today's Topics:
1. Re: mailing list created (Fathi Boudra)
2. Re: 4.2.4 Release Schedule (Mike Fedyk)
3. Re: Why include a SQL file when we don't use it? (Jeff
Kowalczyk)
4. Re: Why include a SQL file when we don't use it?
(Michel JACQUEMES)
5. Re: Why include a SQL file when we don't use it?
(Sergio A. Kessler)
6. Anyone working on Postgres support? (Mike Fedyk)
7. 4.2.4 installer creates tables as MyISAM (Mike Fedyk)
8. Re: Anyone working on Postgres support? (Allan Bush)
9. Re: Anyone working on Postgres support? (Mike Fedyk)
10. Re: 4.2.4 installer creates tables as MyISAM (Mike Fedyk)
----------------------------------------------------------------------
Message: 1
Date: Wed, 22 Feb 2006 08:49:50 +0100
From: Fathi Boudra <fboudra at free.fr>
Subject: Re: [Vtigercrm-developers] mailing list created
To: vtigercrm-developers at lists.vtigercrm.com
Message-ID: <200602220849.50875.fboudra at free.fr>
Content-Type: text/plain; charset="utf-8"
> The new mailing list for commits has been created as mentioned
earlier.
> vtigercrm-commits at lists.vtigercrm.com is the new id.
commits are now redirected to vtigercrm-commits at lists.vtigercrm.com
list.
all (4.x and 5.x) commits go to this list, please use your filter
provided by your email client if you want just a branch.
cheers,
Fathi
------------------------------
Message: 2
Date: Wed, 22 Feb 2006 04:03:28 -0800
From: Mike Fedyk <mfedyk at mikefedyk.com>
Subject: Re: [Vtigercrm-developers] 4.2.4 Release Schedule
To: vtigercrm-developers at lists.vtigercrm.com
Message-ID: <43FC5310.90206 at mikefedyk.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Did I say May? Sorry that should have been *March* 1st.
Mike
Mike Fedyk wrote:
> Hi everyone,
>
> I am planning on releasing 4.2.4rc1 on Friday, so let's get in all of
> the changes that are planned for 4.2.4 before then so we can release
> on May 1st.
>
> Mike
>
------------------------------
Message: 3
Date: Wed, 22 Feb 2006 08:51:43 -0500
From: Jeff Kowalczyk <jtk at yahoo.com>
Subject: Re: [Vtigercrm-developers] Why include a SQL file when we
don't use it?
To: vtigercrm-developers at lists.vtigercrm.com
Message-ID: <pan.2006.02.22.13.51.42.974774 at yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1
http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/28
"use adodb schema to install database schema on multiple backends, avoid
.sql files"
------------------------------
Message: 4
Date: Wed, 22 Feb 2006 15:55:12 +0100
From: Michel JACQUEMES <m.jacquemes at neuf.fr>
Subject: Re: [Vtigercrm-developers] Why include a SQL file when we
don't use it?
To: vtigercrm-developers at lists.vtigercrm.com
Message-ID:
<!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAA4thkWTj0xGwkwBABTMROMKA
AAAQAAAAEqAZ+8JIOU6kQQjWrIAuYQEAAAAA at neuf.fr>
Content-Type: text/plain; charset=iso-8859-1
I have followed with some interest mails on this subject. Having worked
a bit on MsSQL implementation, I will say that use of adodb is probably
better. But doing so you solve multi bases installation but what you
install won't work.
You have to change the code everywhere to avoid static or dynamic
queries builds which are not compatible with other databases. I am not
experienced enough with adodb to say if GetInsertSQL, GetUpdateSQl,
GenID and Insert_ID can solve the problem.
Another way could be to implement something looking like language
support, having subdirectories for each databse and the convenient code
in them.
Having a bit of experience on Delphi and object Pascal, I could also
suggest to use a datasource object in charge of the interface between
displaying data and database access. But maybe that adodb do that
anyway.
Michel
-----Message d'origine-----
De?: vtigercrm-developers-bounces at lists.vtigercrm.com
[mailto:vtigercrm-developers-bounces at lists.vtigercrm.com] De la part de
Jeff Kowalczyk
Envoy??: mercredi 22 f?vrier 2006 14:52
??: vtigercrm-developers at lists.vtigercrm.com
Objet?: Re: [Vtigercrm-developers] Why include a SQL file when we don't
use it?
http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/28
"use adodb schema to install database schema on multiple backends, avoid
.sql files"
_______________________________________________
This vtiger.com email is sponsored by: Zoho Writer. Are you still using
your desktop word processor for typing documents? Try the AJAX enabled,
collaboration-friendly online word processor, Zoho Writer for FREE
instead!
http://zohowriter.com/?vt
------------------------------
Message: 5
Date: Wed, 22 Feb 2006 15:48:30 -0300
From: "Sergio A. Kessler" <sergiokessler at gmail.com>
Subject: Re: [Vtigercrm-developers] Why include a SQL file when we
don't use it?
To: vtigercrm-developers at lists.vtigercrm.com
Message-ID:
<49216030602221048v7c568d20u448ee8ccb58e99e9 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
mike is rigth that the adodb schema has advantages over sql files, but I
also understand fathi problems WRT packaging
maybe something like this can be done:
php generate_sql.php mysql > vtiger-mysql.sql
and eventually:
php generate_sql.php pgsql > vtiger-pgsql.sql
??
so all the sql files are automatically created ?
On 2/21/06, Mike Crowe <mike at mikeandkellycrowe.com> wrote:
> Folks,
>
> I refer you to my post:
> http://forums.vtiger.com/viewtopic.php?t=4535&highlight=
>
> To install from command line:
> php install.php
> where install.php is:
> <?
> require_once('config.php');
> require_once('connection.php');
> require_once('adodb/adodb.inc.php');
> require_once('adodb/adodb-xmlschema.inc.php');
>
> $conn = ADONewConnection($dbconfig['db_type']);
> $conn->Connect($dbconfig['db_host_name'],$dbconfig['db_user_name'],
> $dbconfig['db_password'],$dbconfig['db_name']);
> $schema = new adoSchema( $conn );
> $schema->SetUpgradeMethod('ALTER');
> $schema->ExecuteInline(true);
> $sql = $schema->ParseSchema( "adodb/DatabaseSchema.xml" ); ?>
>
> To create the XML file, all it takes is:
> $schema = new adoSchema( $conn );
> $t = $schema->ExtractSchema(true);
> (now write $t to the xml file)
>
> Mike
>
>
> On Tuesday 21 February 2006 6:34 pm, Fathi BOUDRA wrote:
> > > I don't understand half of what you just said but using the adodb
> > > xml file for database creation is one of the only thing this
> > > project does right, please continue to use it.
> > >
> > > The adodb xml file it designed to be cross database compatible,
> > > the only thing it depends on is adodb which is already a
> > > requirement, using it will save you tons of "copy and paste" code
> > > "reuse" which just leads to bugs.
> >
> > more simple that you can understand :
> > can you give me a simple command line that i can use to install
> > database on windows and linux ?
> >
> > something that can replace something like :
> > mysql < file.sql
> > _______________________________________________
> > This vtiger.com email is sponsored by: Zoho Writer. Are you still
> > using your desktop word processor for typing documents? Try the AJAX
> > enabled, collaboration-friendly online word processor, Zoho Writer
for FREE instead!
> > http://zohowriter.com/?vt
>
> --
> _____________________________________________________
> Cheers!
>
> Mike Crowe
> Sr. Field Sales Engineer
> ELCOM
>
> 3030 Naomi Dr.
> Clover, SC 29710
> Phone: (803) 831-9050
> Fax: (704) 973-7910
>
> mike.crowe at elcomsales.com
> http://www.elcomsales.com/
> _______________________________________________
> This vtiger.com email is sponsored by: Zoho Writer. Are you still
using your desktop word processor for typing documents? Try the AJAX
enabled, collaboration-friendly online word processor, Zoho Writer for
FREE instead!
> http://zohowriter.com/?vt
>
------------------------------
Message: 6
Date: Wed, 22 Feb 2006 14:34:23 -0800
From: Mike Fedyk <mfedyk at mikefedyk.com>
Subject: [Vtigercrm-developers] Anyone working on Postgres support?
To: vtigercrm-developers at lists.vtigercrm.com
Message-ID: <43FCE6EF.7000603 at mikefedyk.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hi,
I'd like to do a release candidate by Friday, feb 24th, so if someone
has any patches for postgres support please get them in the tracker
before Friday so it can be reviewed and integrated.
Mike
------------------------------
Message: 7
Date: Wed, 22 Feb 2006 15:55:16 -0800
From: Mike Fedyk <mfedyk at mikefedyk.com>
Subject: [Vtigercrm-developers] 4.2.4 installer creates tables as
MyISAM
To: vtigercrm-developers at lists.vtigercrm.com
Message-ID: <43FCF9E4.2020404 at mikefedyk.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Just tried creating a database with the latest 4.2 branch as of rev 3889
and all tables are created as MyISAM tables (the ones that don't support
FK constraints and all those nice DB features).
I'm going to have to do this install with 4.2.3 for now... Will look at
it in a bit.
Mike
------------------------------
Message: 8
Date: Wed, 22 Feb 2006 21:45:28 -0800
From: "Allan Bush" <allan.bush+vtiger_dev at gmail.com>
Subject: Re: [Vtigercrm-developers] Anyone working on Postgres
support?
To: vtigercrm-developers at lists.vtigercrm.com
Message-ID:
<3bec26390602222145l3797d3b0j361c0748108b0cb4 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Mike,
I actually have a request out right now for someone to branch 4.2 so I
can work on postgres support (I guess the request isn't all that public
though as it's hidden inside a bug report that's probably not being
read). I don't think this is something we should try and shoe horn in
last minute as there's a pretty good chance of breaking stuff if there
isn't extensive testing. That said most of the work has already been
done and I can probably find time tomorrow to merge everything in if
everyone is prepared for the possible issues (I would still prefer to
work in a separate branch).
Allan
On 2/22/06, Mike Fedyk <mfedyk at mikefedyk.com> wrote:
> Hi,
>
> I'd like to do a release candidate by Friday, feb 24th, so if someone
> has any patches for postgres support please get them in the tracker
> before Friday so it can be reviewed and integrated.
>
> Mike
> _______________________________________________
> This vtiger.com email is sponsored by: Zoho Writer. Are you still
using your desktop word processor for typing documents? Try the AJAX
enabled, collaboration-friendly online word processor, Zoho Writer for
FREE instead!
> http://zohowriter.com/?vt
>
------------------------------
Message: 9
Date: Wed, 22 Feb 2006 22:17:24 -0800
From: Mike Fedyk <mfedyk at mikefedyk.com>
Subject: Re: [Vtigercrm-developers] Anyone working on Postgres
support?
To: vtigercrm-developers at lists.vtigercrm.com
Message-ID: <43FD5374.3020802 at mikefedyk.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
I can make a branch. Though I'd like a consensus on this.
I'd also need to know the name of the branch, could call it
"4.2_postgres" or something...
Comments anyone?
Allan Bush wrote:
>Mike,
>
>I actually have a request out right now for someone to branch 4.2 so I
>can work on postgres support (I guess the request isn't all that public
>though as it's hidden inside a bug report that's probably not being
>read). I don't think this is something we should try and shoe horn in
>last minute as there's a pretty good chance of breaking stuff if there
>isn't extensive testing. That said most of the work has already been
>done and I can probably find time tomorrow to merge everything in if
>everyone is prepared for the possible issues (I would still prefer to
>work in a separate branch).
>
>Allan
>
>On 2/22/06, Mike Fedyk <mfedyk at mikefedyk.com> wrote:
>
>
>>Hi,
>>
>>I'd like to do a release candidate by Friday, feb 24th, so if someone
>>has any patches for postgres support please get them in the tracker
>>before Friday so it can be reviewed and integrated.
>>
>>Mike
>>_______________________________________________
>>This vtiger.com email is sponsored by: Zoho Writer. Are you still
using your desktop word processor for typing documents? Try the AJAX
enabled, collaboration-friendly online word processor, Zoho Writer for
FREE instead!
>>http://zohowriter.com/?vt
>>
>>
>>
>
>_______________________________________________
>This vtiger.com email is sponsored by: Zoho Writer. Are you still using
your desktop word processor for typing documents? Try the AJAX enabled,
collaboration-friendly online word processor, Zoho Writer for FREE
instead!
>http://zohowriter.com/?vt
>
>
>
------------------------------
Message: 10
Date: Thu, 23 Feb 2006 00:23:51 -0800
From: Mike Fedyk <mfedyk at mikefedyk.com>
Subject: Re: [Vtigercrm-developers] 4.2.4 installer creates tables as
MyISAM
To: vtigercrm-developers at lists.vtigercrm.com
Message-ID: <43FD7117.4010309 at mikefedyk.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
It's in this changeset:
http://vtiger.fosslabs.com/cgi-bin/trac.cgi/changeset/3796
Still investigating...
Mike
Mike Fedyk wrote:
>Just tried creating a database with the latest 4.2 branch as of rev
>3889 and all tables are created as MyISAM tables (the ones that don't
>support FK constraints and all those nice DB features).
>
>I'm going to have to do this install with 4.2.3 for now... Will look
>at it in a bit.
>
>Mike
>_______________________________________________
>This vtiger.com email is sponsored by: Zoho Writer. Are you still using
your desktop word processor for typing documents? Try the AJAX enabled,
collaboration-friendly online word processor, Zoho Writer for FREE
instead!
>http://zohowriter.com/?vt
>
>
>
------------------------------
_______________________________________________
vtigercrm-developers mailing list
vtigercrm-developers at lists.vtigercrm.com
http://lists.vtigercrm.com/mailman/listinfo/vtigercrm-developers
End of vtigercrm-developers Digest, Vol 2, Issue 49
***************************************************
More information about the vtigercrm-developers
mailing list