[web2py] Re: database shootout

2013-05-28 Thread Cliff Kachinske
They list Psycopg2 among the installed gadgets. This will definitely push me in their direction. On Monday, May 27, 2013 9:08:30 PM UTC-4, Monte Milanuk wrote: On 05/27/2013 09:29 AM, Ricardo C�rdenas wrote: PythonAnywhere is a terrific option; I'm a bit surprised they don't

Re: [web2py] Re: database shootout

2013-05-28 Thread Ricardo Cárdenas
Just got email from a PA developer saying they're hoping to have Postgres 9.2 out next month. Good news! On Tue, May 28, 2013 at 8:23 AM, Cliff Kachinske cjk...@gmail.com wrote: They [PythonAnywhere] list Psycopg2 among the installed gadgets. This will definitely push me in their direction.

Re: [web2py] Re: database shootout

2013-05-27 Thread Alexei Vinidiktov
I can't give you any specifics right now as I haven't done any migrations in a long time but the next time I come across what I think to be a bug I'll be sure to post here. It'll be really great if we can fix those glitches. On Sun, May 26, 2013 at 8:38 PM, Massimo Di Pierro

[web2py] Re: database shootout

2013-05-27 Thread memilanuk
On 05/27/2013 09:29 AM, Ricardo Cárdenas wrote: PythonAnywhere is a terrific option; I'm a bit surprised they don't offer Postgres. Maybe someone with influence on the PythonAnywhere folks can give them a nudge? Could push many projects their way. I've been following their 'forum' for a

Re: [web2py] Re: database shootout

2013-05-26 Thread Alexei Vinidiktov
I use Firebird with web2py but I often have problems migrating db schemas because of incorrect sql migration scripts that web2py issues. On Sat, Mar 9, 2013 at 1:04 AM, pjag pjagiel...@gmail.com wrote: web2py works nicely with Firebird DB. Highly recommended. On Thursday, March 7, 2013

Re: [web2py] Re: database shootout

2013-05-26 Thread Massimo Di Pierro
Can you tell us more. I believe firebird does not support multiple alter tables in transaction and that is cause of some problems. Make sure you always mgrate one table at the time. On Sunday, 26 May 2013 06:24:49 UTC-5, Alexei Vinidiktov wrote: I use Firebird with web2py but I often have

Re: [web2py] Re: database shootout

2013-03-10 Thread LightDot
I'm not even remotely suggesting anyone should use Fedora for a production server, that'd be nuts. Not so much because of the stability, but the release cycle is completely inappropriate, you'd have to upgrade the OS every 13 months at best, even if you skip every second release and stick with

Re: [web2py] Re: database shootout

2013-03-09 Thread Michele Comitini
I have been using postgresql years before it had its actual name and I found their statement The world's most advanced open source database, always true. Not anymore, I think now they could remove the open source words. ;-) ;-) Use postgresql. The people leading a free software project and

Re: [web2py] Re: database shootout

2013-03-09 Thread Cliff Kachinske
I love the IDEA of Fedora, but I don't use it. Fedora is Red Hat's experimental, community-based product. It's bleeding edge. That means stuff is often broken and changes in direction are not impossible. This is not what I need, especially for a production server. On Friday, March 8, 2013

[web2py] Re: database shootout

2013-03-08 Thread Vineet
That's true. But 'Serial' gives four-byte integer (no other option). In MySQL's autoincrement, we can define it on any size of variable (tinyint, mediumint, int, etc.). This would make a difference when data size is large. -- --- You received this message because you are subscribed to the

[web2py] Re: database shootout

2013-03-08 Thread Niphlod
This is going nuts. He was fine until now with SQLite, either one of mysql or postgres will do fine, with a total preference on postgres if he doesn't want to employ a legal office to know if he can use mysql or not. PS: the day I'm going to choose mysql over postgres for the combined

[web2py] Re: database shootout

2013-03-08 Thread Cliff Kachinske
It's not just the legal aspect. After seeing how poorly Oracle supported OpenOffice, I would be concerned about their future support for MySQL as well. On Friday, March 8, 2013 4:43:06 AM UTC-5, Niphlod wrote: This is going nuts. He was fine until now with SQLite, either one of mysql or

Re: [web2py] Re: database shootout

2013-03-08 Thread Richard Vézina
@Cliff MariaDB!! :) Richard On Fri, Mar 8, 2013 at 7:36 AM, Cliff Kachinske cjk...@gmail.com wrote: It's not just the legal aspect. After seeing how poorly Oracle supported OpenOffice, I would be concerned about their future support for MySQL as well. On Friday, March 8, 2013 4:43:06

[web2py] Re: database shootout

2013-03-08 Thread Massimo Di Pierro
Sorry I misunderstood your previous statement. On Friday, 8 March 2013 03:09:31 UTC-6, Vineet wrote: That's true. But 'Serial' gives four-byte integer (no other option). In MySQL's autoincrement, we can define it on any size of variable (tinyint, mediumint, int, etc.). IMHO, this

[web2py] Re: database shootout

2013-03-08 Thread pjag
web2py works nicely with Firebird DB. Highly recommended. On Thursday, March 7, 2013 3:41:18 PM UTC-5, BlueShadow wrote: Hi guys so I learned that using SQLlite for me wasn't a great choice(thanks Niphlod). But since I started using databases when I started to use web2py. I got no clue

Re: [web2py] Re: database shootout

2013-03-08 Thread Cliff Kachinske
@Richard Yeah, I know. But what about documentation? The MySQL code itself is free open source, but Oracle owns the copyright on the MySQL documentation. So as the MariaDB fork adds features, the MySQL documentation becomes more and more inaccurate. At some point there will have to be a

Re: [web2py] Re: database shootout

2013-03-08 Thread Richard Vézina
Thanks Cliff I wasn't about that issue, it's good to know that. I would be really curious to know if the MySQL user base had splitted since the MariaDB fork and what the proportion that stays with MySQL and now with MariaDB... Richard On Fri, Mar 8, 2013 at 3:17 PM, Cliff Kachinske

Re: [web2py] Re: database shootout

2013-03-08 Thread LightDot
I don't know in terms of user numbers but mysql is getting replaced with mariadb in Fedora, which will have some impact. Current plan for Fedora 19 is this: - mariadb package will provide mysql - existing mysql package will be renamed to MySQL - mariadb and MySQL pacakges conflict, they can't be

[web2py] Re: database shootout

2013-03-07 Thread Vineet
The only con with postgres is that it doesn't support autoincrement field by default. We need to create a 'sequence' and an 'after insert trigger' for it. :( MySQL has built-in support for auto-increment field.:) But otherwise, postgres is totally free for any purpose (they say that no

[web2py] Re: database shootout

2013-03-07 Thread Massimo Di Pierro
This is not true. In fact web2py uses the PostgreSQL auto increment feature: create table something { id SERIAL PRIMARY KEY } This is all you need. This is even simpler the mySQL: CREATE TABLE something ( id MEDIUMINT NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ) ENGINE=InnoDB; This