The gotchas on MySQL are quite scary but also ...quite old. They relate to version 4.1 and most of us are using 5.x so I am not sure how relevant these gotchas are. I feel I am pretty good with SQL in general - but not that good as to start a discussion on which DB is better: Postgres vs. MySQL besides - W2P is not the forum for that, right ?
Hope you'll agree though, that for somebody coming from MS Access (been there, done that) - ANY RDBMS is better and a true opportunity to grow... ;-)) On Wednesday, February 19, 2014 1:48:05 PM UTC-5, Derek wrote: > > friends don't let friends use mysql. It's not standards compliant, and has > a lot more gotchas. use Postgres, > > example: > http://sql-info.de/postgresql/postgres-gotchas.html > http://sql-info.de/mysql/gotchas.html > > On Saturday, February 15, 2014 3:22:59 PM UTC-7, NeoToren wrote: >> >> Web2Py is the glue between a database and the user interface - say a web >> site, HTML pages. >> It doesn't have a database, so you'll need to use either SQLite (built in >> every Mac) or some other DB. >> Personally I suggest using MySQL - it is open source, industrial strength >> and will help you grow out of MS Access into a real-world database. >> >> When you'll have everything up and running on your local machine - you'll >> need to deploy to a hosting service so people can access your app over the >> web. >> >> Creating a phone book like you have mentioned is really easy - both on >> the DB side and the Web2Py side. >> I have managed to create one in several hours when I've started learning >> Web2Py. >> I have tried other "glue" frameworks before W2P, such as Django, PHP and >> others. >> >> W2P is by far the most friendly one I have tried and it will take you >> from 0 to a reasonable level in literally a couple of days. >> >> Good luck and have fun >> >> On Saturday, February 15, 2014 9:35:49 AM UTC-5, jimbo wrote: >>> >>> Hi I am thinking of using web2py for a small database instead of MS >>> Access. It is for a charity and would have only several hundred records of >>> employees and a table for clients. It would run on a local network with >>> probably only two computers using it. The usual name, address , tel no. and >>> some certificate and photo. It would avoid licence fees for a start and I >>> think easier to use via a browser >>> >>> I know a little about Access but very basic. Are there any simple >>> examples of where I could start, or some web2py appliance available? >>> >>> If any you can help or have something I can look at I would be very >>> grateful. It's as much a learing thing for myself as I know virtually >>> nothing aobut DB's. >>> >>> >>> Thanks, Jim >>> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
