John Sladek on 14 Jun 2008 17:18:48 -0700


[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PLUG] Database Front Ends - Similar to MS Access


I'd stick with the web pages.. Of course I'd use PHP but that is just what I 
perfer..  Who are you developing the Database for?  If it is for your own 
personal use or your creating something that the user is going to run on 
their own computer and you know what the platform is then I guess it really 
does not matter but if you want others to be able to use it no matter what 
system they are using then the web scripts are the way to go if.  If you 
just want something to manipulate the data why not phpMyadmin 
http://www.phpmyadmin.net/home_page/index.php or even mysql quick admin 
http://www.mysqlquickadmin.com/

John

----- Original Message ----- 
From: "Casey Bralla" <MailList@NerdWorld.org>
To: "Philadelphia Linux User's Group Discussion List" 
<plug@lists.phillylinux.org>
Sent: Saturday, June 14, 2008 7:21 AM
Subject: [PLUG] Database Front Ends - Similar to MS Access


> Back in the good old days (aka "the Stone Age"), I was quite an expert in
> Foxpro.  Using stone knives and bear skins, I wrote several applications 
> in
> Foxpro that were pretty complex and effective.
>
> A few years ago (think "Bronze Age"), I wrote a couple of reasonably 
> complex
> applications in MS Access.
>
> Now it's time to move into the current age, and I want to use an open 
> source
> database front end.
>
> I've already got a very large, but relatively primitive database 
> application
> in mySQL.  Unfortunately, it's got a series of overly complex interlocking
> custom python scripts and web pages to view and manipulate the data.
>
> I want to start using an open source front end to mySQL that will let me
> continue to run my mySQL applications, but give me improved 
> maintainability
> and a path to eventually eliminate the existing scripts.
>
> I'm considering 4 applications, each with it's pluses and minuses:
>
> 1.  Rekall.
> Very nice and reasonably vibrant development.  A few quirky things I don't
> like, but my best choice so far.
>
> 2.  Knoda
> I like the style of this, but it looks like development stopped in 2004.
> Also, it does not seem as well developed as Rekall
>
> 3.  Kexi
> I like the style of this one, especially as it ties in with KDE (my 
> preferred
> desktop), but it won't interface to an existing mySQL database.  (You have
> to "import" the database, which is then separate from the original 
> operating
> database.)
>
> 4.  OpenOffice Base
> I couldn't get the darn thing to work.  Probably a good long term strategy
> because it will continue to be developed, but way too awkward to use for 
> me.
>
>
>
> Am I missing any?   Which would you use?
>
> -- 
>
>
> Casey Bralla
> Chief Nerd in Residence
> The NerdWorld Organisation
> ___________________________________________________________________________
> Philadelphia Linux Users Group         --  
> http://www.phillylinux.org
> Announcements - 
> http://lists.phillylinux.org/mailman/listinfo/plug-announce
> General Discussion  --  
> http://lists.phillylinux.org/mailman/listinfo/plug
> 


___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug