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
o
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
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 Goo
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
requireme
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 p
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 fl
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
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 littl
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
>
@Cliff MariaDB!!
:)
Richard
On Fri, Mar 8, 2013 at 7:36 AM, Cliff Kachinske 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 AM UTC-5, N
@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 full
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 wrote:
> @
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 b
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
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 6:
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
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 wrote:
> web2py works nicely with Firebird DB. Highly recommended.
>
>
> On Thursday, March 7, 2013 3:41:18 PM UTC-5, Bl
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 pr
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 <
massimo.dipie...@g
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 wrote:
> They [PythonAnywhere] list Psycopg2 among the installed gadgets. This
> will definitely push me in their direction.
--
---
You
20 matches
Mail list logo