Posts
Xataface is a full-featured PHP Web application framework for building a
MySQL database front-end for, targeted at non-technical users who will
do the task of actually entering data. Based on real life experience of
using it for a search and comparison website for smart devices, we
explain the why and how of using it.
In web development the focus is always on the development side. But what about the infrastructure, the crucial data backend that the web site is going to operate on?
It really depends on the content. In some cases a CMS will be enough but in a data-driven web site like that of an e-shop where you have to combine information from a variety of tables staying true to the relational model, a CMS might not be the most appropriate solution. So where does that leaves us?
Entering data using raw SQL queries might be possible for a low volume site with simple entity relationships, but for anything more involved it's not practical.
We faced this dilemma when building Smart Device Seeker, a tablet, smart phone and smart watch search and comparison engine, built in Mysql, Perl and the Dancer framework. As a site with a complex ERD and continuously updated content, a solution was required that would allow non developers and end users to be able to populate the database through an easy to use data entry interface.
full article on i-programmer
In web development the focus is always on the development side. But what about the infrastructure, the crucial data backend that the web site is going to operate on?
It really depends on the content. In some cases a CMS will be enough but in a data-driven web site like that of an e-shop where you have to combine information from a variety of tables staying true to the relational model, a CMS might not be the most appropriate solution. So where does that leaves us?
Entering data using raw SQL queries might be possible for a low volume site with simple entity relationships, but for anything more involved it's not practical.
We faced this dilemma when building Smart Device Seeker, a tablet, smart phone and smart watch search and comparison engine, built in Mysql, Perl and the Dancer framework. As a site with a complex ERD and continuously updated content, a solution was required that would allow non developers and end users to be able to populate the database through an easy to use data entry interface.
full article on i-programmer
Comments