StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I switched from PHP/MySQL (CakePHP, mostly) to web2py/PostgreSQL in the spring. I can confirm that the web2py community is more oriented toward Postgres and you are more likely to find an answer to specific questions relating to the DAL if you use Postgres. And you should check the licensing requirements of both systems to be sure that both match your business needs -- MySQL's licenses have undergone some changes recently with the change in ownership.</p> <p>One thing to think about is that if you are new to web2py, you will be learning two new technologies at the same time, and both fundamental to your project. I switched from being very comfortable on MySQL to very awkward on PostgreSQL. I assumed -- wrongly, it turned out -- that SQL is SQL. Well, just about every common command is totally different in Postgres. The queries themselves are similar, but you likely won't be composing any manual queries anyway if you're using web2py; you'll be using the DAL syntax to query to DB. At the least, take a good look at some <a href="http://blog.endpoint.com/2009/12/mysql-and-postgres-command-equivalents.html" rel="nofollow">comparisons</a> between the commands of the two systems. There's a world of difference. Postgres commands are much shorter ("dt" instead of "show tables") but much less intuitive.</p> <p>In short, PostgreSQL is a great RDBMS, but you may want to wait until you're comfortable with web2py before you switch. The great thing about web2py and the DAL is that you <em>can</em> switch database systems, even after you've created your app. You may face some hurdles if/when you switch databases, but you can get those straightened out here or on the web2py users e-mail list (on groups.google.com).</p> <p>PS -- Regardless of which database you choose, unless your database schema is set in stone, be sure to take the time to fully understand the web2py DAL, particularly the uses of and differences between the "migrate" and "fake_migrate" arguments. You will become well acquainted with <a href="http://web2py.com/book/default/chapter/06" rel="nofollow">chapter 6 of the web2py book</a>. </p> <p>The good news is that the rest of web2py is a breeze.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload