JFDraw 1.6.0 (Default branch)

Grok Headline matches for JFDraw 1.6.0 (Default branch)

JFDraw 1.1.1

JFDraw 1.1.1 09/23/2004 01:11 PM
A vector graphics application and library package.

JFDraw 1.0.1

JFDraw 1.0.1 08/22/2004 06:21 AM
A vector graphics application and library package.

JFDraw 1.1.0

JFDraw 1.1.0 09/12/2004 01:45 AM
A vector graphics application and library package.

JFDraw 1.4.0

JFDraw 1.4.0 12/31/2004 03:32 AM
A vector graphics application and library package.

Ivy 1.0-rc2 (Default branch)

Ivy 1.0-rc2 (Default branch) 04/18/2005 06:37 PM
Ivy is a simple but powerful dependency manager. Its key features are ease of use, extreme flexibility, easy extensibility, Ant integration, and transitive dependencies. It is ready to use with the Maven ibiblio repository. It eases continuous integration, and makes your software component a lot simpler to use.

---

Changes:
Several bugfixes, especially one in handling relative paths and backslashes in paths.

Xen 2.0.5 (Default branch)

Xen 2.0.5 (Default branch) 03/23/2005 07:00 PM
Xen is a virtual machine monitor for x86 that supports execution of multiple guest operating systems in isolated environments.

---

Changes:
Various minor bugfixes and code cleanups were done.

qGo 1.0.1 (Default branch)

qGo 1.0.1 (Default branch) 03/31/2005 07:22 AM
qGo is a Go board, SGF editor, and client for the Internet Go Server. You can review and edit games, connect to IGS, and play against a computer program supporting GTP (like GnuGo). Go is an ancient board game which is very common in Japan, China, and Korea.

---

Changes:
IGS rooms and better handling of GNUgo.

XQF 1.0.3 (Default branch)

XQF 1.0.3 (Default branch) 04/06/2005 02:28 AM
XQF is Quake/QuakeWorld/Quake2/Quake3 server browser and launcher for Linux/X11. It's a frontend to QStat, a program by Steve Jankowski. XQF uses the GTK+. For more information, screenshots, source code, precompiled binaries, see the XQF Homepage.

---

Changes:
This release adds support for Half-Life 2 under Wine and has a new improved look using GTK2 colors and the Raleigh theme (if available). A new command line option to disable map scanning is available, along with various fixes such as UT2004 and Doom 3 master support, Quake 2 password saving, Q1/QW/Q2 skin list updating, and improved GTK2 support.

im-ja 1.4 (Default branch)

im-ja 1.4 (Default branch) 04/12/2005 05:18 PM
im-ja aims to be a generic Japanese input module for GTK+ 2. The currently supported input modes are Hiragana, Katakana, Half-Width Katakana, Zenkaku, Canna, Wnn, Anthy, and Kanji character recognition (based on Kanjipad).

---

Changes:
Changes include compose sequence and system tray support in addition to some minor fixes.

P4A 0.15 (Default branch)

P4A 0.15 (Default branch) 04/18/2005 11:02 AM
P4A (PHP For Applications) is a PHP object oriented framework for building Web-based event-driven applications. It features tableless HTML, accesskey support, point and click app generator, auto data type recognition, UTF-8 support, advanced i18n/l10n support, and PEAR integration.

---

Changes:
This release fixes some i18n/l10n bugs in the "products_catalogue" application and allows p4a_message to handle messages without icons.

OSS 3.99.2c (Default branch)

OSS 3.99.2c (Default branch) 03/23/2005 07:00 PM
OSS provides sound card drivers for most popular sound cards under Linux, *BSD, Solaris, UnixWare, OpenServer, AIX, HPUX, LynxOS, VxWorks, and Tru64. These drivers support digital audio, MIDI, synthesizers, and mixers found on sound cards. These sound drivers comply with the Open Sound System API specification. OSS provides a user-friendly GUI which makes the installation of sound drivers and configuration of sound cards very simple. It supports over 200 brand name sound cards, and provides automatic sound card detection, Plug-n-Play support, support for PCI audio soundcards, and support for full duplex audio.

---

Changes:
Fixes were made for Envy24 memory allocation under BSD. Fixes were made for LynxTWO drivers for Linux. Fixes were made to the audio core for nonblocking support for BSD.

Wi-viz 1.0 (Default branch)

Wi-viz 1.0 (Default branch) 04/18/2005 11:11 PM
Running on a Linksys WRT54G or compatible router powered by the Linux firmware OpenWRT, Wi-viz places the wireless apparatus into a special monitor mode that doesn't interfere with the operation of the router. Here it sits, examining all wireless packets coming into the interface and extracting valuable information about the surrounding wireless infrastructure. With an intuitive Web interface, it exposes this information in a simple, easy-to-use, self-arranging graphical format.

Ivy 0.8 (Default branch)

Ivy 0.8 (Default branch) 03/31/2005 09:17 AM
Ivy is a simple but powerful dependency manager. Its key features are ease of use, extreme flexibility, easy extensibility, Ant integration, and transitive dependencies. It is ready to use with the Maven ibiblio repository. It eases continuous integration, and makes your software component a lot simpler to use.

---

Changes:
This release feature a new public repository of ivy files, ivyrep, which helps leverage the transitive dependencies feature. The URL resolver handles file and HTTP URLs, and you can use the continuous integration feature with ibiblio. A publish artifacts feature allows you to easily publish declared artifacts of a module to a repository. Conflict management at resolve time allows you to detect and remove modules that will cause problems before downloading them.

Ivy 1.0-rc1 (Default branch)

Ivy 1.0-rc1 (Default branch) 04/12/2005 05:18 PM
Ivy is a simple but powerful dependency manager. Its key features are ease of use, extreme flexibility, easy extensibility, Ant integration, and transitive dependencies. It is ready to use with the Maven ibiblio repository. It eases continuous integration, and makes your software component a lot simpler to use.

---

Changes:
A new report that indicates all the dependencies resolved, direct and transitives, with the status and place in the dependency graph for each. A new graph report showing all dependencies as a graph. A better include/exclude feature, helping to get only what you need from a dependency you do not control.

gcx 0.8.6 (Default branch)

gcx 0.8.6 (Default branch) 02/05/2005 09:34 PM
GCX provides a complete set of data-reduction functions for CCD photometry, with frame WCS fitting, automatic target identification, aperture photometry of target and standard stars, single-frame ensemble photometry data reduction, multi-frame color coefficient fitting, extinction coefficient fitting, and all-sky photometry. It also controls CCD cameras and telescopes, and implements automatic observation scripting. Cameras are controlled through a hardware-specific server, to which gcx connects through a TCP socket. The program can control telescopes which use the LX200 protocol, and refine pointing by matching images to the GSC catalog position of stars. It generates FITS files with comprehensive header information.

---

Changes:
This release supports moving photometry targets (comets and asteroids). The ccd reduction dialog has been reorganized.

DBG 2.11.32 (Default branch)

DBG 2.11.32 (Default branch) 02/01/2005 09:44 PM
DBG is a PHP debugger and profiler. It makes it much easier to discover the origins of problems and bugs in PHP scripts. It's equipped with the ability to backtrace errors. It shows local and global variables as well as parameters which have been passed to all nested function calls at any point of execution. Among other things, it allows you to execute scripts in a step-by-step manner, set breakpoints (including conditional ones), evaluate expressions, and watch variables. The profiler allows you to find bottlenecks in PHP code at the functions level as well as the modules level and even the source lines level.

---

Changes:
This release adds support for hardened PHP, and support for PHP 5.0.3, 5.0.2, 4.3.9, and 4.3.10. It adds three new commands to dbg-cli: -list, -listen, and -output. It also fixes problems with the PCRE library.

R 2.1.0 (Default branch)

R 2.1.0 (Default branch) 04/18/2005 12:51 PM
R is a language and environment for statistical computing and graphics. It is similar to S, which was developed at Bell Laboratories by John Chambers et al. It provides a wide variety of statistical and graphical techniques (linear and nonlinear modelling, statistical tests, time series analysis, classification, clustering, etc.). R is designed as a true computer language with control-flow constructions for iteration and alternation, and it allows users to add additional functionality by defining new functions. For computationally intensive tasks, Fortran and C code can be linked and called at run time.

---

Changes:
The most important changes are probably support for UTF-8 encodings and internationalization, including (partial) translations of menus, warnings, and error messages to Chinese, German, Italian, Japanese, Portugese, and Russian.

Tor 0.0.9.8 (Default branch)

Tor 0.0.9.8 (Default branch) 04/08/2005 03:11 PM
Tor is a network of virtual tunnels that allows people and groups to improve their privacy and security on the Internet. It also enables software developers to create new communication tools with built-in privacy features. It provides the foundation for a range of applications that allow organizations and individuals to share information over public networks without compromising their privacy. Individuals can use it to keep remote Websites from tracking them and their family members. They can also use it to connect to resources such as news sites or instant messaging services that are blocked by their local Internet service providers (ISPs).

---

Changes:
This release has a workaround for a rare bug that makes servers stop processing new circuits.

PMD 3.2 (Default branch)

PMD 3.2 (Default branch) 06/22/2005 02:26 AM
PMD is a Java source code analyzer. It finds unused variables, empty catch blocks, unnecessary object creation, and more. It includes CPD, a tool to detect chunks of identical code.

---

License: BSD License (original)

---

Changes:
Three new rules were added. Bugfixes were made. Various internal improvements were done to make writing rules easier.

bdb 0.2.6 (Default branch)

bdb 0.2.6 (Default branch) 03/22/2005 03:52 PM
bdb is a bibliography database with a flexible Web-based interface. One can easily add items to the database, search for information in the database, and generate reports.

SoC GDS 5.5.0 (Default branch)

SoC GDS 5.5.0 (Default branch) 03/30/2005 06:14 PM
SoC GDS is a platform for enabling hierarchical SoC integration and verification across traditional EDA frameworks based on Virtual Components per the VSIA guidelines. It is also a fast viewer and processor for native GDSII files. It encompasses a set of powerful functions allowing automatic cell renaming, grid verifications, GDS II files merging (AND), physical comparison (XOR), hierarchy modifications, and conversion to text format.

---

Changes:
This release provides extended management of technology files through design kits and Cadence techfile compatibility; LEF reading, validation and display; and hierarchical LEF/GDSII comparison as well as DRC annotation display.

Maw 1.1 (Default branch)

Maw 1.1 (Default branch) 06/22/2005 02:26 AM
Maw is mostly black, but it's got lots of blues, purples, and reds in it too. There is also a GTK theme and a GKrellM theme. There are several backgrounds bundled with this theme, including some original ones. It uses the Nexis font.

---

License: GNU General Public License (GPL)

---

Changes:
This release fixes some sloppy graphics editing on the opening pixmap and scales it to not tile on displays as high as 2048x1536.

AAF SDK 1.1.0 (Default branch)

AAF SDK 1.1.0 (Default branch) 04/15/2005 03:24 PM
AAF SDK is a cross-platform SDK that supports the Advanced Authoring Format (AAF). AAF is a metadata management system and file format for use in professional multimedia creation and authoring. The AAF specification is administered by the AAF Association, which also coordinates development of the SDK.

---

Changes:
Major new APIs to support 1.1 of the AAF specification. Several APIs have been extended, and there are many bugfixes to existing APIs and plugin codecs. The codecs DV (within the CDCI codec) and PCM, including the BWF container, have been added. The 2GB filesize limit found on some platforms has been fixed. New utilities: aafextract, aaf2xtl, aafdump. Support for the x86_64 target and UTF-8 filenames has been added. libgsf has been added to available Structured Storage implementations. The plugin loading search path has been fixed to be consistent across all platforms.

SAM Jr 0.3 (Default branch)

SAM Jr 0.3 (Default branch) 04/18/2005 11:04 AM
SAM Jr is a real-time analysis tool for Snort data. It can easily be extended using plugins.

---

Changes:
This release adds a script to email the whois and other info of any IP address with a very high threat index, serving as a complex script example, JavaMail jar files and a SimpleMailSender class, database port number configurability, a whois lookup facility, and keyboard shortcuts for menus.

lvs-rrd v0.6 (Default branch)

lvs-rrd v0.6 (Default branch) 04/08/2005 06:05 PM
lvs-rrd is a tool to collect connection data from an LVS, store them in RRD files, and later graph that data so that trends can be observed.

---

Changes:
This release adds support for specifying the protocol (tcp|udp). A verbose option has been added, and a small change to the PHP page has been made.

ANA-MP 0.9.7.4 (Default branch)

ANA-MP 0.9.7.4 (Default branch) 04/05/2005 06:49 PM
ANA-MP is a player for music files (modules) in the .MOD, .XM, and .S3M formats. It runs on any platform with a Java 1.3 implementation, and can be used as a library for playing music in games or demos.

---

Changes:
This release makes the player API much easier to use and understand. Several simple code examples of how to create command line or applet based module players have been added.

GTK+ 2.6.6 (Default branch)

GTK+ 2.6.6 (Default branch) 04/12/2005 08:00 AM
GTK, which stands for the Gimp ToolKit, is a library for creating graphical user interfaces. It is designed to be small and efficient, but still flexible enough to allow the programmer freedom in the interfaces created. GTK provides some unique features over standard widget libraries.

---

Changes:
This release mainly fixes a problem with stock images. It also fixes several bugs and adds translations.

BRL-CAD 7.2.2 (Default branch)

BRL-CAD 7.2.2 (Default branch) 04/03/2005 07:41 PM
BRL-CAD is a powerful constructive solid geometry solid modeling system that includes an interactive geometry editor, ray tracing support for rendering and geometric analysis, network distributed framebuffer support, and image and signal-processing tools.

---

Changes:
An rtedge/rtwizard background render failure bug has been fixed. An rttherm previous results interference bug has been fixed. An aborted benchmark summary bug has been fixed. The irprep 'display' tool has been renamed to 'showtherm'. An XInputExtension warning on mged startup has been quelled. The object name is output when the root solver fails to converge. Non-square window mged illumination selection has been fixed.

CK-ERP 0.12.1 (Default branch)

CK-ERP 0.12.1 (Default branch) 04/06/2005 02:28 AM
CK-ERP is an ERP system for use by SMEs. Its features include accounting ledger, accounts payable, accounts receivable, purchase order, sales order, quotation, POS, human resources, payroll, contact management, CRM, and vendor relationship. It operates as modules running atop phpGroupWare and is an extension of CK-Ledger.

---

Changes:
In this version, a new contact infrastructure was implemented in the HR modules.

imc 4.3 (Default branch)

imc 4.3 (Default branch) 04/03/2005 03:38 PM
imc is a Perl script that accepts a file with graphical commands and outputs a PNG, GIF, or JPEG file.

---

Changes:
This release re-adds GIF support, and allows you to use literal double quotes and backslashes in strings by escaping them using a backslash.

vok 1.1 (Default branch)

vok 1.1 (Default branch) 04/03/2005 07:42 PM
vok is a vocabulary trainer written with OpenOffice macros.

Qps-h 1.9.9.1 (Default branch)

Qps-h 1.9.9.1 (Default branch) 03/17/2005 03:35 AM
Qps is a GUI version of "ps" and "top" . It is a perfect visual process manager that displays processes in a window and lets you sort and manipulate them easily.

---

Changes:
The "no kicker" problem was fixed. Any window manager is now supported.

g4u 2.1 (Default branch)

g4u 2.1 (Default branch) 06/22/2005 02:25 AM
g4u ("ghost for unix") is a boot-floppy/CD that allows one to easily clone PC hard disks by using FTP. This is often done to deploy a common setup on a number of PCs. The floppy/CD offers two functions: it uploads the compressed image of a local hard disk to an FTP server, and then it can retrieve that image via FTP, uncompress it, and write it back to disk. Network configuration is fetched via DHCP. As the hard disk is processed as an image, any filesystem and operating system can be deployed using g4u. Easy cloning of local disks as well as partitions is also supported.

---

License: BSD License (original)

---

Changes:
Serial drivers were added again for those people that need serial console. Support for IT Express and ATI IXP IDE and Promise SATA150 controllers was added. Many bugfixes and enhancements were taken from NetBSD-current, including EHCI-based USB improvements. "dmesg" now hints at pressing space/CR to scroll down.

Zsh 4.2.5 (Default branch)

Zsh 4.2.5 (Default branch) 04/06/2005 09:59 AM
Zsh is a UNIX command interpreter (shell) which of the standard shells most resembles the Korn shell (ksh). It includes enhancements of many types, notably in the command-line editor, options for customising its behaviour, filename globbing, features to make C-shell (csh) users feel more at home and extra features drawn from tcsh.

---

Changes:
This is a bug fix release for the stable 4.2 series. It fixes a few configuration problems, notably on Mac OS X, as well as a number of other minor issues. There are also some upgrades to completion functions. Upgrading from 4.2.4 should not cause any incompatibilities.

nut 10.17 (Default branch)

nut 10.17 (Default branch) 04/03/2005 07:54 AM
nut is nutrition software to record what you eat and analyze your meals for nutrient composition. The database included is the USDA Nutrient Database for Standard Reference, Release 17, which contains 6,839 foods and 128 nutrients. This database contains values for vitamins, minerals, fats, calories, protein, carbohydrates, fiber, etc., and includes the essential polyunsaturated fats, Omega-3 and Omega-6. Nutrient levels are expressed as a percentage of the Daily Value, the familiar standard of food labeling in the United States, but also can be fully customized. Foods can be added from recipes or food labels, and nutrient intake can be graphed. The program is completely menu-driven and there are no commands to learn.

---

Changes:
This release corrects the formatting of the man page and restores the correct alpha-linolenic acid reference value, which was too low in the last release.

otl 0.26 (Default branch)

otl 0.26 (Default branch) 04/08/2005 04:27 AM
otl is a Perl application that is a glorified search and replace engine. The process is customizable; the application can be used to generate markup such as HTML, XML, etc. from a text file with the user able to customize the process to a substantial extent. While the program is designed to be used to process outlines (e.g. lecture notes, etc.) and generate nice HTML, it could be used in other contexts, as well by just defining a new set of rules for the substitution process.

---

Changes:
In this version, nested lists are processed better, and there is improved documentation in the HOWTO . A GNU autoconf automake framework was added so install is more of a no- brainer, a --pfile flag is now used to indicate a parameter file, filename globbing is now dealt with, the parameter file was modified so it specifies the file suffix to tag on output file, diagnostic information that is written to stdout has been trimmed, the project now checks to see if the file is already present before overwriting, and a second script, "tag- remove", was added.

Vex 1.2.0 (Default branch)

Vex 1.2.0 (Default branch) 03/23/2005 05:18 AM
Vex is a visual editor for XML. It features a word processor-like interface.

---

Changes:
This release features easier extension with new doctypes and styles via the new plug-in project mechanism, basic DITA support, the ability to specify which style a document should be shown with, and improved CSS support.

nut 10.16 (Default branch)

nut 10.16 (Default branch) 03/23/2005 04:56 PM
nut is nutrition software to record what you eat and analyze your meals for nutrient composition. The database included is the USDA Nutrient Database for Standard Reference, Release 17, which contains 6,839 foods and 128 nutrients. This database contains values for vitamins, minerals, fats, calories, protein, carbohydrates, fiber, etc., and includes the essential polyunsaturated fats, Omega-3 and Omega-6. Nutrient levels are expressed as a percentage of the Daily Value, the familiar standard of food labeling in the United States, but also can be fully customized. Foods can be added from recipes or food labels, and nutrient intake can be graphed. The program is completely menu-driven and there are no commands to learn.

---

Changes:
This release fixes a segfault that occurs when analyzing added and subtracted foods that total zero calories.

lat 0.5 (Default branch)

lat 0.5 (Default branch) 03/27/2005 10:12 AM
LAT stands for LDAP Administration Tool. It allows you to browse LDAP-based directories and add/edit/delete entries contained within. It can store profiles for quick access to different servers.

---

Changes:
A search builder and support for user-defined views were added. Various bugfixes were made.
Grok Description matches for JFDraw 1.6.0 (Default branch)
GrokA matches for JFDraw 1.6.0 (Default branch)

Filesystem data visualization using
JPGraph

Filesystem data visualization using
JPGraph 03/14/2005 04:05 PM
JPGraph is a set of programs written in PHP that plots data into a wide range of graphs and formats the results. Licensed under the Trolltech QPL License, JPGraph is now at Version 1.17. Whatever your data, JPGraph can help you to view it graphically, letting you to see relations in more clearly. Such data visualization may not be important to a computer, but, to a person, it can make a lot of difference to analysis.

NewsForge: Filesystem Data Stats Using
JPGraph

NewsForge: Filesystem Data Stats Using
JPGraph 03/14/2005 05:04 PM
From PHP Magazine today:

NewsForge: Filesystem Data Visualization
using JPGraph

NewsForge: Filesystem Data Visualization
using JPGraph 03/14/2005 05:34 PM
"JPGraph is a set of programs written in PHP that plots data into a wide range of graphs and formats the results..."

How to access MySQL data in Filemaker
via ODBC

How to access MySQL data in Filemaker
via ODBC 02/10/2004 12:01 PM
In order to import data from a MySQL database into FileMaker 6 via ODBC, do not install the DataDirect ODBC driver that comes with FileMaker. Instead, download the OpenLink one.If you decided to install the DataDirect driver...

EnGarde Secure Linux Advisory: MySQL,
MySQL-client, MySQL-shared, mod_php, php

EnGarde Secure Linux Advisory: MySQL,
MySQL-client, MySQL-shared, mod_php, php 12/16/2002 04:17 PM
"Stefan Esser from the PHP.net project discovered two vulnerabilities in MySQL which range from crashing the server to executing arbitrary code as the user under which the MySQL daemon runs (mysql)..."

JpGraph 1.16 (Stable)

JpGraph 1.16 (Stable) 06/20/2004 08:19 AM
An OO graph drawing class library for PHP.

JpGraph 1.15 (Stable)

JpGraph 1.15 (Stable) 05/04/2004 01:48 PM
An OO graph drawing class library for PHP.

Introduction to JPGraph (Part I)

Introduction to JPGraph (Part I) 10/29/2003 12:11 AM
Are you interested in creating graphs, pie charts etc. and make your site lively. Go ahead and read this tutorial.

JpGraph 1.17beta (Stable)

JpGraph 1.17beta (Stable) 09/12/2004 08:49 AM
An OO graph drawing class library for PHP.

JpGraph 1.7 (Stable) released

JpGraph 1.7 (Stable) released 07/04/2002 11:25 AM
JpGraph is a OO Graph drawing library for PHP 4.0.2 and above. Highlights of the available features are: text, linear, and log scales for both the X and Y axes, anti-aliasing of lines, color-gradient fills, support for GIF, JPG, and PNG formats, support for two Y axes, spider plots (a.k.a Web plots), pie-charts, lineplots, filled line plots, impulse plots, bar plots, and error plots, support for multiple plot types in one graph, intelligent autoscaling, and extensive documentation (145 pages).

JpGraph 1.18 (Stable branch)

JpGraph 1.18 (Stable branch) 06/05/2005 11:22 PM
JpGraph is an OO Graph drawing library for PHP 4.3.x and above. Highlights of the available features are: text, integer/linear, and log scales for both the X and Y axes; anti-aliasing of lines; color-gradient fills; support for GIF, JPG, and PNG formats; support for two Y axes, spider plots (a.k.a Web plots), pie-charts, lineplots, filled line plots, impulse plots, bar plots, error plots, and polar plots; Gantt charts; support for multiple plot types in one graph; intelligent autoscaling; and extensive documentation (150 pages).

---

License: Free for non-commercial use

---

Changes:
This release has a new date/time scale, a new guide-line algorithm for PiePlots, various minor bugfixes, and documentation updates.

Introduction to JPGraph (Part II)

Introduction to JPGraph (Part II) 10/29/2003 12:11 AM
In this Part II tutorial we will be dealing with creating pie charts.

SearchEnterpriseLinux: MySQL CEO: Open
Source MySQL Will Rise, Legal Foes Will
Fall

SearchEnterpriseLinux: MySQL CEO: Open
Source MySQL Will Rise, Legal Foes Will
Fall 02/01/2005 09:06 PM
"None of the legal attacks on open source or Linux have been successful. None of that stuff has gone anywhere. That's the biggest story..."

Access vs MySQL

Access vs MySQL 09/14/2004 01:10 PM
---

High Performance MySQL (the book) is
Shipping!

High Performance MySQL (the book) is
Shipping! 04/19/2004 04:32 PM
As noted on our site for the book, O'Reilly brought the first copies to the 2004 MySQL User's Conference in Orlando and it had sold out by the middle of the second day. Woohoo! Now Amazon reports that the book is shipping in 1-2 weeks (rather than being pre-order), and we even have our first customer review posted too. I read the front matter and first three chapters on the plane ride home last night, pen in hand. I didn't...

Web Database Applications with PHP and
MySQL: A Book Review

Web Database Applications with PHP and
MySQL: A Book Review 06/26/2002 01:02 PM
A useful book that offers a lot of varied information in one place for updating your skills.

Book Review: High Performance MySQL

Book Review: High Performance MySQL 07/27/2004 06:25 PM
"In the first chapters, the authors briefly review some basics of MySQL. The concepts they discuss are pertinent to database performance. Chapter 1 explains the configuration file my.cnf and how it can be set to improve a MySQL server. The authors also discuss the results of the SHOW VARIABLES statement and the SHOW PROCESSLIST statement so that an administrator can determine where the MySQL service is being slowed because of inefficiencies." Story

Build Your Own Database Driven Website
Using PHP & MySQL

Build Your Own Database Driven Website
Using PHP & MySQL 06/26/2002 01:02 PM
This book is ideal for users willing to get started on the development of dynamic Web pages using PHP and MySQL. If you are a newcomer to the world of these programming tools or are considering to enter this world, this book is most suited to your needs.

Building a Database-Driven Website Using
PHP and MySQL

Building a Database-Driven Website Using
PHP and MySQL 06/11/2002 09:56 AM
In affiliation with Sitepoint.com we bring you an in-depth tutorial about how to create a database-driven website with PHP and MySQL. This tutorial provides a hands-on look at what's involved. By the end of this tutorial you should come away with everything you need to get started on your very own database-driven site in no time!

Re: Horde webmail: mysql access

Re: Horde webmail: mysql access 04/28/2004 11:55 AM
Christopher T. Beers (Apr 26 2004)

Horde webmail: mysql access

Horde webmail: mysql access 04/26/2004 07:06 PM
sig_at_flaming.tolna.net (Apr 25 2004)

DataWerkz: FileMaker-like access for
MySQL, PostgreSQL

DataWerkz: FileMaker-like access for
MySQL, PostgreSQL 04/20/2004 08:43 AM
New developer Uwerkz opened their doors on Monday with the release of DataWerkz 1.0, a Mac OS X application that offers a graphical user interface for creating, accessing and editing MySQL and PostgreSQL databases. The company notes that the access is similar to what's found in FileMaker Pro.

Book Review: Mastering phpMyAdmin for
Effective MySQL Management

Book Review: Mastering phpMyAdmin for
Effective MySQL Management 12/17/2004 06:23 PM
This well-written book by one of the leaders of the phpMyAdmin community covers a lot of ground--and might get you interested in working on the project.

Mysql Data Manager 1.72'

Mysql Data Manager 1.72' 12/25/2003 04:21 PM
Advanced client for Mysql over TCP/IP.

Backing up your MySQL data

Backing up your MySQL data 12/27/2004 03:08 AM
If you have ever pulled your hair out in frustration over data loss, no doubt the word 'backup' has special meaning in your life. Databases offer a nice way to catalog data, but with the amount of data being trusted into MySQL databases these days, the after-effects of an unwise DROP DATABASE command, an unlucky system crash, or a failed hand-edit of the table structure are catastrophic and can be unrecoverable -- unless you have a backup to restore from.

MySQL and Terabytes of Data?

MySQL and Terabytes of Data? 12/06/2002 04:09 PM
It sounds like I'll be helping with some multi-terabyte MySQL tests in the not too distant future. This is good not just because I get to play with neat toys, but it'll finally help me to answer the "how well...

Adding & Changing Data in MySQL

Adding & Changing Data in MySQL 04/09/2004 04:05 PM
"There are several ways to add and to change data in MySQL. There are a few SQL statements that you can use, each with a few options. Additionally, there are twists that you can do by mixing SQL statements together with various clauses, some of which are available with the release of version 4 of MySQL. In this article, I will explore the ways in which data can be added and changed in MySQL." Story

Data Globbing with MySQL Regex

Data Globbing with MySQL Regex 07/13/2004 11:50 PM

As I become a more experienced developer, I'm learning when you should and shouldn't break the rules. While following every rule of programming and data modeling is wonderful, sometimes you need to bend the rules for the sake of simplicity and expediency.

Always remember, an app in the hand is worth a thousand on the white board.

This being the case, lately I've been known to "glob" up data in database fields. Yes, I know this breaks the first normal form — that of atom icity — but there are times when doing it right would involve three more queries, two more database tables, another UI screen, etc. Often it makes the cure worse than the disease.

For instance, consider this little XML document as the contents of the "children" field for one of the records in my "church_attender" table:


<children>
  <child>
    <first_name>Isabella</first_name> ;
    <last_name>Barker</last_name>
  </child>
  <child>
    <first_name>Gabrielle</first_name&g t;
    <last_name>Barker</last_name>
  </child>
</children>



Now if I never wanted to search for individual children, I would make no excuses for this. It saves us a database table, a join, and a ton of complexity in the interface. Life is good.

Searching a globbed up field is a problem, though. We alluded to it in this post when we said:

However, the problem is that the XML field is a black box that — on most database platforms — you can't look inside. What if you want a list of articles written by a particular author? Well, you need to use SQL to get all the XML back, spin that collection, XPath into every single one to find the value author of the author node, then keep that record it matches.

So what if I want to find a person with a child named Gabrielle? Some databases (Oracle, for one), will let you do something like this:


SELECT * FROM church_attender WHERE XPATH(children,'/child/first_name') = 'Gabrielle'


That'd be great, but I don't have Oracle. However, given our experience this week with MySQL regular expressions, how unacceptable would this be:


SELECT * FROM church_attender WHERE children LIKE '%Gabrielle%' AND children RLIKE '<children>.*<child>.*<first_name> Gabrielle </first_name>.*</child>.*</children>'


(Note that there are some extra spaces in there just so the lines would wrap.)

Yes, yes, I know the database Gods would frown on this, but given the enourmous amount of complexity it would save us, is it acceptable? Does the good outweigh the bad?

Fishing for opinions here. Let's hear them.

Click here to comment on this entry

Transferring Data to MySQL Using SQLyog

Transferring Data to MySQL Using SQLyog 03/11/2003 01:23 AM
Need any easy way to import data from your ODBC-compliant database into MySQL? Look no further than SQLyog's ODBC Import tool. Read all about it inside.

NewsForge: Backing Up Your MySQL Data

NewsForge: Backing Up Your MySQL Data 12/28/2004 07:36 PM
"If you have ever pulled your hair out in frustration over data loss, no doubt the word 'backup' has special meaning in your life..."

JFDraw 1.6.0 (Default branch)

The following phrases have been identified by the grok system as matching this entry: use jpgraph antispam access ascii data from mysql and plot using jpgraph "php mysql website programming" scanned book