https://www.portcommodore.com/dokuwiki/ 2026-09-26T21:24:20+00:00 https://www.portcommodore.com/dokuwiki/ https://www.portcommodore.com/dokuwiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2020-11-22T15:55:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.portcommodore.com/dokuwiki/doku.php?id=blog:2010_07:07-05_necessity_is_the_mother_of_invention&rev=1606060529&do=diff Necessity is the Mother of Invention Most inventions are made because people develop an answer to a need. Regardless of the education or skills of the creator, invention still happens. When I read about how you need this degree or that education to be a productive member of modern society I recall newsreels Ive seen from the 1920s and 1930s of lots of ordinary Joes' working on new inventions text/html 2020-11-22T15:55:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.portcommodore.com/dokuwiki/doku.php?id=blog:2010_07:07-08_lamp_rocks&rev=1606060529&do=diff LAMP Rocks! A few years ago I had to revamp our database (written in FoxBase), after frustration with Microsoft's FoxPRO (don't trust MS for supporting thier Applications) much research I chose (without knowing it) the LAMP stack, which consists of: text/html 2020-11-22T15:55:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.portcommodore.com/dokuwiki/doku.php?id=blog:2010_07:07-10_my_table_field_naming_tips&rev=1606060529&do=diff My Table Field Naming Tips There are lots of guidelines for naming functions, objects and variables in PHP and other languages but when I started with MySQL I didnt find one that applied to databases. Fortunately I did one I saw once in an example (I don't remember where) and have added to it. text/html 2020-11-22T15:55:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.portcommodore.com/dokuwiki/doku.php?id=blog:2010_07:07-12_unique_record_ids&rev=1606060529&do=diff Unique Record IDs If you do a search for Unique Record IDs you will probably find several hits, as it is one of the common problems in data application design, many use a serial number or hashed random number with some check to verify that there is not other occurrence of the number in the table