-
Five Reasons To Use PostgreSQL
Date: 08/18/06
(Java Web) Keywords: database, sql, postgresql
Five reasons, without the satire, for using PostgreSQL open source database.
Availability on multiple platforms
PostgreSQL is available on every modern Unix-compatible operating system, windows, and ports are also available for Novell NetWare and OS/2.
Professional development and administration tools
The following list summarizes just a few of the tools available to PostgreSQL developers:
Database modeling: Several commercial and open [...]
Source: http://blog.taragana.com/index.php/archive/five-reasons-to-use-postgresql/
-
Help!
Date: 08/20/06
(WebDesign) Keywords: database, web
I work at a little gift shop in Morro Bay, CA and I am trying to do my boss a favor and re-do her website to help her save money and to make it look much more professional. However, I do not have any knowledge or experience in creating databases or online ordering forms. Or really, even what I need to create an extensive online store for her shop. This is the link of the current online store and mine will be similar only much more extensive. If anyone could give me any pointers on how I can go about recreating this, let me know!
HEATHER
P.S. The temporary site that I am making is located here. Feel free to leave me constructive criticism.
Source: http://community.livejournal.com/webdesign/1153253.html
-
Ideas on handling recurring events
Date: 08/22/06
(PHP Community) Keywords: database
I am setting up an LAMP based events calendar for a client and they want to be able to add recurring events. Whats the best way to add recurring event functionality. Will I have to set up a cron script to add the events to the calendar once a day based on criteria in the database or is there an easier way?
Source: http://community.livejournal.com/php/486432.html
-
PHP help?
Date: 08/26/06
(Computer Geeks) Keywords: php, database
I need some php help. Given this code:
$dateThen = SomeDatabaseCallThatReturnsADate();
$dateNow = /* code to set the date right now */
return (/* code to compare */);
Where code to compare is code that returns TRUE if it is now the day after $dateThen or later.
That is, regardless of the time, if $dateThen is August 29th, I will return true only if it is August 30th or later. If $dateThen is August 31st, I will return true only if it is September 1st or later.
Make sense?
PS: This isn't a homework assignment - I'm doing a quick mod to a Joomla component :-)
Source: http://community.livejournal.com/computergeeks/970452.html
-
Apple WebObjects going open source?
Date: 08/26/06
(Open Source) Keywords: database
What seems obvious to me is that Apple fears the database market within its OS is under severe threat from open source, and that it needs to give something back to its user base in order to stay in contention there.
Source: http://blogs.zdnet.com/open-source/?p=766
-
PHP LiveJournal client
Date: 08/28/06
(PHP Community) Keywords: php, xml, database
I'm planning to write a cross-posting module fo Drupal. The idea is that when a member on the Drupal site updates her blog, the entry is cross-posted to her livejournal. The database structure and interaction I can handle, but I'm a little confused about what to do for the client code.
My plan is to use the XML-RPC interface to Livejournal, and code the client in PHP. I could use the base interface, but I'm wondering if anyone has written a library that might speed up my development. Does anyone have any suggestions?
Source: http://community.livejournal.com/php/489173.html
-
godaddy.com == useless
Date: 08/29/06
(PHP Community) Keywords: php, software, database, sql, hosting
With their refusal to upgrade to php5 and let you install any kind of third party software they have effectively rendered themselves useless to me. With that said, does anyone know of any good hosting providers with ssh access? I'm wanting to use smarty, and play around with the Zend framework so I need php5. Also need some databases, I don't know if the free sql databases were just a godaddy thing or not, I hope not. thanks.
Source: http://community.livejournal.com/php/489542.html
-
Web host searching
Date: 08/29/06
(Web Development) Keywords: php, mysql, software, database, sql, linux, hosting
I see that this forum recommends Dreamhost. How long have you been using it? Are they located in the U.S.? I don't know if the latter is necessary, but I guess if a host goes down and loses everyone's files, there could be a group law suit with some recovery. I don't know what to worry about the most, but I did go with a service once that suddenly disappeared. Luckily I had a techie who found the files still available somewhere and transferred them to another server for me.
I'm not a "techie". I'm also not a "designer" so if you check out my sites, please be kind on the critique of their appearance (search engine optimization and user-friendly access is my biggest concern).
I'm presently using a really cheap hosting service for one of my sites, 3ix. My son has used it for 2 yrs. with no problem. Has anyone here used them?
I have a site I need to move over to a server with Linux, MySQL, lots of database space available, lots of free software available, including PHP. 3ix offers a lot of software. Any suggestions would be appreciated.
Source: http://community.livejournal.com/webdev/350691.html
-
U.K.'s Home Office admits to database breaches
Date: 08/31/06
(Security) Keywords: database
The government agency says four of five incidents involved members of staff accessing databases for unauthorized purposes.
Source: http://news.zdnet.com/2100-1009_22-6111358.html
-
Freeware search
Date: 09/02/06
(MySQL Communtiy) Keywords: mysql, database, sql, hosting
Anyone know of a freeware tool to Synchronize a MySQL testing server on my machine, a MySQL remote server on my firm's server, and a MySQL client's server. Trick is that the database name's for each server is different according to each server's hosting scheme. Local has no prefix but the firm and client server's have prefix's. I have to do it in stages test->firm, test->client... that's fine because its better then nothing.
otherwise I am just going to write a script to try and transfer data between the servers with the testing server being the master of the others.
Source: http://community.livejournal.com/mysql/102449.html
-
Software vendors add tips to flaws database
Date: 09/07/06
(Security) Keywords: software, database
The National Vulnerability Database expands its information to include comments from software vendors on reported flaws.
Source: http://news.zdnet.com/2100-1009_22-6113232.html
-
Update On Super Simple Java ORM Replacement in 80 Lines
Date: 09/13/06
(Java Web) Keywords: database, java
I have been inundated with emails after my article Java Database Framework (ORM Replacement) in 80 Lines of Code, asking for the source code of the framework or if I could release it as open source. I haven’t been yet able to individually reply to all of them, sorry. I have decided to release it [...]
Source: http://blog.taragana.com/index.php/archive/update-on-super-simple-java-orm-replacement-in-80-lines/
-
Dual Boot, use same Databases?
Date: 09/21/06
(MySQL Communtiy) Keywords: php, mysql, database, sql
My laptop dual boots Windows XP and Ubuntu with a shared FAT32 drive they can both access. I'm working on a PHP project and ideally I would like both XP and Ubuntu to be able to access the same databases. Does anybody know if this is possible? ie, install MySQL on both OSes but somehow have them look on the shared drived for the actual database files? Any pointers / guides you guys could give me would be greatly appreciated!
Source: http://community.livejournal.com/mysql/103467.html
-
Getting a specific category while using JOINed tables
Date: 09/25/06
(MySQL Communtiy) Keywords: mysql, database, sql
Hello,
I'm making a wallpaper database for my site, and I have two tables: wallpapers and wpartist. The wallpapers table holds all of the wallpaper info (obviously), while the wpartist table has the info on the artists who made the wallpapers. The two tables are JOINed by the artistid field.
Right now I'm able to show all wallpaper results, but I would like to also be able to show only a certain category, like a specific character. Is it possible to do that now that WHERE is being used by the joined tables? Here is the code I'm using now:
$result = mysql_query
("SELECT * FROM wallpapers, wpartist
WHERE wallpapers.artistid = wpartist.artistid
order by date desc");
I hope you guys can help! =)
Source: http://community.livejournal.com/mysql/104162.html
-
Print to pdf programmatically, Outlook OLE access message
Date: 09/28/06
(IT Professionals) Keywords: database
anyone has any clue how to do this in a freeware manner?
I'm writing a program that will read the latest email from outlook and store it in a database blob as a pdf file.
the reading from outlook is mostly ok, except that outlook comes up with this access warning which I must figure out how to disable it
1)
""A program is trying to access e-mail addresses you have stored in outlook,
do you want to allow this?"
How can I disable this message on a permanent basis?
2)
I do have a pretty decent distiller called cutepdf printer, however, each time it prints, it comes up with saveas dialogue, ie: there is no programmatical way to specify filename and click the ok dialogue.
my question regarding point 1 and 2, is there anyway to trigger this remotely via the windows kernel api or something, getwindows or something then remotely triggering the events (using dde?)
Source: http://community.livejournal.com/itprofessionals/43841.html
-
help with passing form data
Date: 10/02/06
(Web Development) Keywords: database, asp
I am currently working in ASP, but this might also be an issue with other types of server-side scripting, so if anyone has suggestions in another language, feel free to let me know!
Currently, I have several forms and I'm trying to consolidate/condense the way the form data is handled and written to a database. I like the idea of using a for...next loop to loop through the form fields instead of multiple 'request.form' statements in order to display the form field values on a confirmation page (before submitting to the db).
The code I'm using is similar to this:
For each inputField in Request.Form
For each inputValue in Request.Form(inputField)
response.write inputField & " = " & inputValue & "
"
Next
Next
However, I'm encountering a couple of issues:
1. The output seems to appear in a completely random order, which isn't very user friendly. e.g. in the form the order might be: name, address, telephone, comments; but the loop output shows it as: name, comments, telephone, address (or something similarly random). the values are all displayed, just in the wrong order.
2. While looping through the form eliminates the need to grab each form field value individually, there are some form field values that I DON'T want displayed on the confirmation screen. Is there any way to set this up without a lot of extraneous 'if' statements?
I thought maybe I need to add the form field values in an array, but I'm not even sure if that is at all useful, i.e. how do I manipulate them afterwards?
Thanks for any help.
Source: http://community.livejournal.com/webdev/357805.html
-
Verifying Basic SQL Functionality
Date: 10/05/06
(SQL Server) Keywords: database, sql
I've been asked by my manager to come up with a script to run before and after an upgrade of SQL server to verify that basic statements within SQL work before and after an upgrade. Here's what I came up with. Anyone else ever do something like this?
/*
SQL Standard Health Check
DBA : Amy Boyd
Date: 10/5/2006
This is a script that can be run prior to and after the upgrade of
SQL server components to verify basic functionality.
*/
set nocount on
select 'Server Name: ' + @@servername + ' at version: ' + @@version
use admin -- or any other test database you might have
select 'Testing a select of a few sysobjects from admin db...'
select * from sysobjects where id < 5
if @@error = 0
begin
select 'Select of sysobjects successful'
select ''
end
select 'Testing table creation'
create table test_upgrade ( message varchar(100))
if @@error = 0
begin
select 'Table creation successful'
select ''
end
select 'Testing Insert into Table'
insert into test_upgrade values ('Table Insert Works')
if @@error = 0
begin
select 'Insert successful'
select ''
end
select 'Testing Update of Table'
update test_upgrade set message ='Table Update Works'
if @@error = 0
begin
select 'Update of table Successful'
select ''
end
select 'Testing Delete from Table'
delete from test_upgrade
if @@error = 0
begin
select 'Delete from table successful'
select ''
end
select 'Testing Drop table command'
drop table test_upgrade
if @@error = 0
begin
select 'Drop of table successful'
select ''
end
use msdb
select 'Testing a select of a few sysobjects from msdb db...'
select * from sysobjects where id < 5
if @@error = 0
begin
select 'Select of sysobjects successful'
select ''
end
use master
select 'Testing a select of a few sysobjects from master db...'
select * from sysobjects where id < 5
if @@error = 0
begin
select 'Select of sysobjects successful'
select ''
end
select 'Retreiving list of databases from ' + @@servername
select * from sysdatabases
select ''
if @@error = 0
begin
select 'Getting disk space stats for ' + @@servername
exec xp_fixeddrives
select ''
end
select 'Basic SQL Operations are working. Do not forget to test start/stop of SQL Server and Agent.'
select ''
if @@error > 0
select 'There was an error executing the health check please verify output for resolution.'
Source: http://community.livejournal.com/sqlserver/52733.html
-
What possible use?
Date: 10/07/06
(Computer Geeks) Keywords: database, linux
Just arrived from an old data center, with a database on them that I safed, backed-up, and then called the job done. Two of the following:
Pentium III 500 MHz processor on a motherboard with AGP (not AGP 2x or 4x, but first-generation AGP)
768 Megabytes of RAM
52X CD ROM
64M Graphics (seriously nothing stellar)
15 GB hard drive
I can't think of much of anything to do with these machines. Sure, I could throw Linux on them, but why? I don't need a UNIX server, I don't need a cheap DNS machine... They'd barely run Windows XP. The memory is PC-133, so no real use for it.
Anything cool I'm overlooking that could be done with these outdated boxen?
Source: http://community.livejournal.com/computergeeks/988628.html
-
Frontpage Class
Date: 10/09/06
(WebDesign) Keywords: programming, database, web
Still trying to figure out if I want to go to Ai online. There are no local college courses around here for me to just go learn how to build a website. I would rather be taught than fish around for information for however many years. Anyhoo - one course around here is for frontpage. $160. A far cry from $15,000. However, I've never heard much about frontpage. A total waste or useful knowledge?
EDIT New Question:
AI online Classes:
* Digital Imaging for Multimedia & Web
* Information Design
* Screen Design and Graphics
* Fundamentals of the World Wide Web
* Basic Web Scripting
* Computer Animation for Multimedia & Web
* Web Site Development
* Sophomore Digital Portfolio
* Introduction to Programming
* Database Systems
* Web Site Development II
* Interactive Telecommunications
cost = $15,000
continuing education around here offers these online courses:
Creating Web Pages
Creating Web Pages 2
Designing Effective Websites
Introduction to Dreamweaver MX 2004
Introduction to Flash MX 2004
cost = $89 per class. Same weekly amount...
i just want a jumping off base. Do the cont. edu classes sound better for the price than the ai bit?
Source: http://community.livejournal.com/webdesign/1177069.html
-
Class action suit over ID theft tossed out
Date: 10/12/06
(Security) Keywords: database
Acxiom, a data warehouser, had its databases looted at least twice. But judge throws out an ID-theft class action suit.
Source: http://news.zdnet.com/2100-1009_22-6125028.html