Student database to be created
120412
Every 14-year-old in England will have their personal details recorded on a permanent database raising privacy fears.
30928
Created expressly for Mac OS X Leopard, Bento, the personal database from FileMaker, has caught fire. As FileMaker announced this morning, customers eager to experience the easy-to-use applications have downloaded more than 100,000 copies of the preview release in just 30 days. Whatâs more, Bento has received excellent reviews. A reviewer at Networkworld.com, for example, said of Bento, âI, for one, never thought Iâd see a database able to achieve that level of simplicity. Yet another reason to consider a Mac?â
535273
PHP driven Inventory, HelpDesk, Support, Issue Tracking, and Knowledge Base web application. Focuses on simplicity and ease of customization. Sort of a mini-Directory solution for SMBs using PHP and any Pear::DB supported database. OpenIT 1.3 represents a major step from 1.2.  Thanks to Aaron's (acolflesh) new "Lookups" section all entries in the database can be edited via OpenIT.  This means no more using phpMyAdmin to add Departments.   Dan (dancoulter) worked hard to get Active Directory authentication to work via LDAP.  This is an exciting feature for anyone using Active Directory.  The coding style is in a state of flux as we're trying to bring it in line with PEAR standards.  There have been minor database changes.  At this point the easiest way to upgrade your database is to do a diff of the old & new tools/setup.php scripts to see what has changed.  Please use this release as much as possible and report bugs on the SourceForge Project Bug tracker & forums.  Note:  From version 1.3 forward OpenIT will follow versioning practices similar to the Linux Kernel.  This means all odd minor number releases (1.3, 2.5, etc.) will be "Testing" releases, while even minor number releases (1.4, 2.0, etc.) will be "Stable" releases.  OpenIT 1.3 Released http://openit.sf.net  This version is availabe here: https://sourceforge.net/project/showfiles.php?group_id=111107&package_id=133178
49069
JabRef is a graphical application for managing bibliographical databases. The main focus is on BibTeX databases, but other database formats will be supported as well. JabRef runs on all platforms and requires java 1.4. The new JabRef version is finally out. Highlights include (configurable) preview with and without abstract, remote Medline search, CiteSeer support, a new dialog for easily creating entries from plain text, a new panel for the Abstract in the entry editor, and numerous usability improvements. And, as usual, many bug fixes.   You can find the latest release here: https://sourceforge.net/project/showfiles.php?group_id=92314&package_id=97632
423942
Aim is to give students easy access to "portable office" software suite designed to operate in Windows environment.
98306
DevShed has started a new MySQL-centric series today with this new tutorial, an initial look at working with MySQL and PHP to perform full-text and boolean searches on your data.   In this series of articles I'm going to show you how to work with full-text and Boolean searches using MySQL and PHP 5, but the entirety of the code samples that will be developed here can be easily modified to work with a different database server.   They start with the creation of a "common approach" for making the requests and fetching the results (in classes so that any other database could be substituted). With the class structure in place, they move on to the full-text searches, showing how to format database tables by creating them with a fulltext index on which ever fields you want.
114793
On his blog today, Lorenzo Alberton Talks about DBMS and the character sets they support and issues a call for help for anyone interested to help them (on the PEAR::MDB2 project) set up proper character set support for each database.    We're working on PEAR::MDB2 charset and collation support. That means that we're in the process of figuring out what's the best way to set the charset in each DBMS, and how to make it portable and consistent through all of them.   I'll try to explain how the various DBMS implement charset settings first, then describe the MDB2 status-quo regarding charset support. Finally, we'd like to get some feedback to implement a better charset support in MDB2.    He lists out the types of character sets - client, connection, database/table/field, and result - explaining each of their roles in the average connection. He then breaks out the different databases into the different settings they support for the different character set types.   The call for help comes in with him asking anyone out there with experience and skill in these areas to get in touch and help out if they can. Contact information is in the post. You can also check out some of Lukas Smith's comments over on his blog too.
515933
Evolt.org has a new tutorial posted today concerning something that I still get a lot of questions about - creating a PHP Login System with Admin Features.
124693
Jared White has posted another Willowgarden highlight to his blog today, this time with a focus on the processing of form input.   In the bad old days of processing forms and saving each field to a column in a database row, you'd have to do a lot of manual gruntwork: accessing each field from the $_POST superglobal, checking the values, constructing the SQL query, connecting to the database and executing the query, and so forth. Wouldn't it be great if you could just import the form right into an object, and let it do the validation and the database saving based on just a few simple rules? Let's take a quick look at how that might work.   He shows how to make an instance of the WFFormCreator class in a simple script and add actions to it to handle the successful submission and the errors that might come up.
629103
One of the most respected engineering gateways on the web has just released four new databases providing free access to hundreds of online scientific and technical journals.
720024
Parind Raval and Siamak Asgari spent six years working for a variety of technology companies while seeking a niche that would allow them to start their own business. Two years ago, Asgari met a school-system official who mentioned the need for an effective student management system in public schools.
347086
On CodePoets.co.uk, there's a new tutorial posted by David Goodwin showing how to use PHP with the PEAR MDB2 component to access your database backend.   While writing some PHP Training materials for Pale Purple, I thought I'd add an updated guide on PHP and database access. I've already done one on PEAR::DB, but PEAR::MDB2 is it's successor and has a slightly different API.... and as PEAR::DB is now deprecated, it's probably about time I rewrote it anyway.   David looks at what the MDB2 package is, how to install it, connecting to your database and including some error handling as well. He (thankfully) also touches on one of the most handy features of the package - the prepared statements and the security they can offer.
663351
On the NorthClick blog today, there's a quick little set of hints talking about the creation of a simple ("but solid") newsletter system for your website.   He breaks it down into the individual steps you'll need to follow:  Use a Framwork Queue in the database Use SMTP Check Headers Test it  In the step involving the database, he gives the create script you'll need to get the table set up and working. It's not so much a step-by-step tutorial with all of the needed code as it is a general look at what steps to follow when rolling your own newsletter setup.
151612
In a new blog entry, Michael Kimsal points out a driver that Microsoft has released (during the end of last year) that allows PHP5 applications to connect directly to a SQL Server database.   This isn't replacing freetds any time soon.  I guess I'm still wondering what the market for "PHP apps deployed on Windows talking to SQL Server" really is - most of the shared hosting accounts I've seen, even on Windows, offer MySQL or Access as the database.    He also points out a video that was shot of the development team talking about the driver (here's their blog too).
663615
AgileWiki explores new knowledge representation. The current effort is on implementing a copy-on-write OODBMS with support for fast deep copies, b-trees, large extensible hashes, simple lists, bush structures and calendars.   CowDb is a new kind of Object Store based on Copy-On-Write technology. It supports fast deep copies, b-trees and large extensible hashes.   http://agilewiki.wiki.sourceforge.net/CowDb
495645
Computer Banc will hold a volunteer orientation Thursday, Sept. 14.  High school and college students are encouraged to attend. Anyone with technical and non-technical skills is invited to help children with technology.
696609
On his blog, Stoyan Stefanov takes a look at using on of the most popular pieces of PHP forum software out there - phpBB - and optimizing the front-end.   During this short workshop there will be no changes to the phpBB code, we'll create a new template instead, so that in case something bad happens, your board will continue to work normally. As an example, I'll use the bgcanada.com/phpBB2, the board I volunteer to administrate.   The tutorial is broken up into sections:   The plan New subdomains Creating a new template Moving CSS to an external file, merging Copying files to the new subdomains Serving gzipped content Turning ETags off Expires header Sysadmin summary   It looks like a lot of steps, but each section is relatively short and written well so as not to have more information than needed. In the end you'll have a simple template that uses Yahoo's 14 optimization rules to make things work that much faster.