Thank you all. I'll take a look at yii and cakephp.
Also, Joseph, are the scripts similar to those here:
http://stackoverflow.com/questions/698839/how-to-extract-the-schema-of-an-access-mdb-database
Regards,
Leo
On 03/12/13 09:43, Joseph Bennie wrote:
>
> database:
>
> I’ll push some simple vba scripts to git that will allow you to extract
> the table structures into mysql or Ms SQL DDL queries
>
> Once you have the data structures exported, you can use a trial version
> of DBcompare or a like tool to move the data from the old db to the
> mysql db … OR just use the access export to dump csv files.
>
> for the application layer/web layer… I’ve used cakephp many times to
> scaffold most of the basic functionality with its inbuilt commands, this
> also builds the models/controllers and default views. Cakephp is an
> established well tuned php MVC framework.
>
> you can then extend the scaffolded pages with custom functions and view
> models (MVVM) or ignore the scaffold and do your own thing. ( also you
> might want to add a javascript layer to the app … i.e. extending table
> functionality with jTable, or date pickers and other widgets with
> jqueryUI or wijimo.
>
> another neat trick with Cakephp is the ease of adding a REST API for the
> future when you needed to build a native mobile client.
>
> I’ve tried using a few of the other options out there but this has been
> the most successful and reliable overall… most of the other point and
> click options fail in some critical aspect or auto generate code hell.
>
> but let me know how you get on with the one below, its not one i have
> tried yet.
>
>
> Joseph Bennie | Founder
> 07976 300036 | @Lincoreltd
> jay@??? <mailto:jay@lincore.com>
>
> On 3 Dec 2013, at 09:26, Paul Freeman <paul@???
> <mailto:paul@noc4.net>> wrote:
>
>> On 2013-12-02 23:19, Leo wrote:
>>
>>> I was thinking of porting a fairly simple [1] Access database to a LAMP
>>> stack with a few web pages to do various updates, searches etc. I was
>>> just wondering, before I start looking, if there's something I could use
>>> that would provide some of this functionality for me off the shelf.
>>> (E.g. maybe something out that would pre-create all the simple single
>>> table CRUD pages for me.)
>>
>> http://www.yiiframework.com/ is worth a look. it will run on a
>> standard LAMP stack.
>>
>>
>> --
>> Please post to: Hampshire@???
>> <mailto:Hampshire@mailman.lug.org.uk>
>> Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire
>> LUG URL: http://www.hantslug.org.uk
>> --------------------------------------------------------------
>
>
>
--
Please post to: Hampshire@???
Web Interface:
https://mailman.lug.org.uk/mailman/listinfo/hampshire
LUG URL:
http://www.hantslug.org.uk
--------------------------------------------------------------
