Re: PostgresSQL or MySql with django?

2013-03-23 Thread frocco
I Just downloaded a product called RazorSQL http://www.razorsql.com This product has conversion from MySql to Postgresql. Works great. On Monday, March 18, 2013 11:30:35 AM UTC-4, frocco wrote: > > Hello, > > What is the recommended database for django? > > I have used MySQL, but am interested

Re: PostgresSQL or MySql with django?

2013-03-21 Thread Alan Johnson
You don't have to have the databases set up at the same time for the django-extensions dumpscript method (nor for the dumpdata method). I haven't used it myself, but as I understand it, the script will contain the data you need. 1. Create the script with existing MySQL running 2.

Re: PostgresSQL or MySql with django?

2013-03-21 Thread Shawn Milochik
On Thu, Mar 21, 2013 at 3:44 PM, Lachlan Musicman wrote: > Frocco, > > No, he's saying you can have two databases set up at the same time. > You can have X databases (I presume). > > Cheers > L. > > On 22 March 2013 01:13, frocco wrote: >> Hi Alan, >> >> so

Re: PostgresSQL or MySql with django?

2013-03-21 Thread Lachlan Musicman
Frocco, No, he's saying you can have two databases set up at the same time. You can have X databases (I presume). Cheers L. On 22 March 2013 01:13, frocco wrote: > Hi Alan, > > so you are saying I should connect django to mysql first and then generate > the script. > Then

Re: PostgresSQL or MySql with django?

2013-03-21 Thread frocco
Hi Alan, so you are saying I should connect django to mysql first and then generate the script. Then connect django to postgresql and do the import? On Thursday, March 21, 2013 9:58:37 AM UTC-4, Alan Johnson wrote: > > I want to echo the support for Postgres. I find it to be a bit more arcane

Re: PostgresSQL or MySql with django?

2013-03-21 Thread Alan Johnson
I want to echo the support for Postgres. I find it to be a bit more arcane than MySQL, but even in an extremely DB intensive app, Django's ORM is so slick that I rarely have to muck around in Postgres land. I think it's * slightly* better supported by Django, if you need to use things like

Re: PostgresSQL or MySql with django?

2013-03-21 Thread frocco
rom:* django...@googlegroups.com [mailto: > django...@googlegroups.com ] *On Behalf Of *frocco > *Sent:* 21 March 2013 13:06 > *To:* django...@googlegroups.com > *Subject:* Re: PostgresSQL or MySql with django? > > > > Has anyone used this? > > > > https://github.com/l

Re: PostgresSQL or MySql with django?

2013-03-21 Thread Tom Evans
On Thu, Mar 21, 2013 at 1:06 PM, frocco wrote: > Has anyone used this? > > https://github.com/lanyrd/mysql-postgresql-converter/ > > I cannot get this working, says cannot find the file > Why not use dumpdata as I suggested? Add your postgresql database connection in Django as

RE: PostgresSQL or MySql with django?

2013-03-21 Thread Patrick Craston
d it can't find the script. From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of frocco Sent: 21 March 2013 13:06 To: django-users@googlegroups.com Subject: Re: PostgresSQL or MySql with django? Has anyone used this? https://github.com/lanyrd/mysql-postgresql-con

Re: PostgresSQL or MySql with django?

2013-03-21 Thread frocco
>> obviously not aware of this) >> >> HTH >> >> Patrick >> >> -Original Message- >> From: django...@googlegroups.com [mailto:django...@googlegroups.com] On >> Behalf Of Tom Evans >> Sent: 20 March 2013 14:12 >> To: djang

Re: PostgresSQL or MySql with django?

2013-03-21 Thread frocco
gres - py-mysql2pgsql is > obviously not aware of this) > > HTH > > Patrick > > -Original Message- > From: django...@googlegroups.com [mailto: > django...@googlegroups.com ] On Behalf Of Tom Evans > Sent: 20 March 2013 14:12 > To: django...@googlegroups

Re: PostgresSQL or MySql with django?

2013-03-20 Thread Jian Chang
postgres! do what you like 2013/3/18 frocco > Hello, > > What is the recommended database for django? > > I have used MySQL, but am interested in Postgres. > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. >

Re: PostgresSQL or MySql with django?

2013-03-20 Thread Felipe Prenholato
I'll bookmark this answer and show to anyone who ask about mysql \m/ Felipe 'chronos' Prenholato. Linux User nº 405489 Home page: http://devwithpassion.com | http://chronosbox.org/blog GitHub: http://github.com/chronossc/ | Twitter: http://twitter.com/chronossc 2013/3/18 Russell Keith-Magee

RE: PostgresSQL or MySql with django?

2013-03-20 Thread Patrick Craston
Message- From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of Tom Evans Sent: 20 March 2013 14:12 To: django-users@googlegroups.com Subject: Re: PostgresSQL or MySql with django? On Wed, Mar 20, 2013 at 1:54 PM, frocco <faro...@gmail.com> wrote: &

Re: PostgresSQL or MySql with django?

2013-03-20 Thread Tom Evans
On Wed, Mar 20, 2013 at 1:54 PM, frocco wrote: > Hello, > > I know this is not django related, but can someone help me with the syntax > to port mysql to postgresql? > I tried the mysqldump command with the postgresql compatibility option, but > I still cannot import the data.

Re: PostgresSQL or MySql with django?

2013-03-20 Thread frocco
Hello, I know this is not django related, but can someone help me with the syntax to port mysql to postgresql? I tried the mysqldump command with the postgresql compatibility option, but I still cannot import the data. Thanks On Monday, March 18, 2013 11:30:35 AM UTC-4, frocco wrote: > >

Re: PostgresSQL or MySql with django?

2013-03-18 Thread Christophe Pettus
On Mar 18, 2013, at 4:50 PM, Russell Keith-Magee wrote: > Summary - if you issue a SELECT query that contains an "WHERE X IS NONE" > clause, and nothing matches the SELECT, and an object was inserted by the > last statement, the SELECT query returns *the primary key of the object that > was

Re: PostgresSQL or MySql with django?

2013-03-18 Thread Lachlan Musicman
On 19 March 2013 10:50, Russell Keith-Magee wrote: > On Tue, Mar 19, 2013 at 12:07 AM, Philip Goh >> In the end, if you're asking this question you can't go far wrong if you >> toss a coin and pick one. > > Much of a muchness? They *really*

Re: PostgresSQL or MySql with django?

2013-03-18 Thread Russell Keith-Magee
On Tue, Mar 19, 2013 at 12:07 AM, Philip Goh wrote: > They're much of a muchness. I've favoured Postgres because it seems more > straightforward as there aren't multiple distributions and crucially > multiple storage engines to worry about. In MySQL's favour, Amazon RDS >

Re: PostgresSQL or MySql with django?

2013-03-18 Thread frocco
Thanks, I purchased this book, I was looking for postgresSQL tutorial On Monday, March 18, 2013 12:38:59 PM UTC-4, Lee Hinde wrote: > > > On Mar 18, 2013, at 9:34 AM, frocco > wrote: > > > Thank you for your feedback. > > Other than the docs, is there a good ebook to

Re: PostgresSQL or MySql with django?

2013-03-18 Thread Chris Streeter
I'd add to this that if you are interested in either running with an async worker like gevent or with Python 3 support, MySQL is a no-go. The main MySQL connector, MySQLdb, doesn't yet support Python 3; work is forthcoming in a branch, though no timeline is given. And if you want to have some sort

Re: PostgresSQL or MySql with django?

2013-03-18 Thread Lee Hinde
On Mar 18, 2013, at 9:34 AM, frocco wrote: > Thank you for your feedback. > Other than the docs, is there a good ebook to learn the basics. I just > purchased navicat to use. > https://django.2scoops.org/ -- You received this message because you are subscribed to the

Re: PostgresSQL or MySql with django?

2013-03-18 Thread frocco
Thank you for your feedback. Other than the docs, is there a good ebook to learn the basics. I just purchased navicat to use. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it,

Re: PostgresSQL or MySql with django?

2013-03-18 Thread Shawn Milochik
Postgres. Just from conversations I've seen in the community, MySQL has a thousand edge-cases which cause problems. From previous conversations on thsi topic, I think more people use Postgres. -- You received this message because you are subscribed to the Google Groups "Django users" group. To

Re: PostgresSQL or MySql with django?

2013-03-18 Thread Philip Goh
They're much of a muchness. I've favoured Postgres because it seems more straightforward as there aren't multiple distributions and crucially multiple storage engines to worry about. In MySQL's favour, Amazon RDS makes it incredibly simple to set up a scalable and reliable database so bear

Re: PostgresSQL or MySql with django?

2013-03-18 Thread Matthias Müller
Make a +1 for postgres. I like the licensemodel of PG more than the license model of Mysql. There's a big community behind (no big company) and there is only one version. Mysql confuses me with the different versions (MariaDB, MySQL..). Since PG has the Hot-Stream-Feature it became more and more