Well, I wouldn't say that any RDBMS is better, msaccess is good, and if they are coming from access, SQL Express is probably a better choice than MySQL or Postgres just because it's similar.
On Wednesday, February 19, 2014 4:07:40 PM UTC-7, NeoToren wrote: > > 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.
