Slashdot Mirror

I have found it incredibly useful, and searching for functions a breeze. If you need to find out a function to perform a particular task, then do a quick google search or go onto irc.openprojects.net or some other server and join a channel and ask for a function - then look that function up on php.net.

If you don't know programming, then a resource I have found useful for web based programming (mysql & php specifically) is www.devshed.com, with tutorials on a few different topics.

For game related programming and a number of topics related to that (opengl, directx, ai, etc) then www.gamedev.net is excellent. For opengl you can't go past NeHe Productions.

Devshed has to be one of the best sites I've come accross for PHP Programming. It has great articles and the forums are fantastic, I've always been able to get help there. It's got other sections besides the PHP and MySQL stuff, but I have no idea how good they are. If your into PHP and/or MySQL or just general web development and you haven't been to devshed.com, then by all means check it out!
--Aaron

Developer Shed (all about using open source technologies):
http://www.devshed.com

Webmonkey:
http://www.webmonkey.com

Both are VERY good.

Yeah, I know it's just a big list of links...

Apache and FW Performance Tips
Apache.org Performance Tuning
Apache Tuning Tips
Apache Tuning Directives
Tuning Your Apache Server
TUNING.txt
PHP-DEV: Database Connection Problems
PHP Everywhere: Tuning Apache and PHP for Speed
Tuning Apache Web Servers for Speed

and last, but not least, my favorite:

Web Server Tuning

I'd also recommend reading up on tuning the linux kernel.

-techwolf

Nothing better than the internet. My favorite is devshed. They have great forums if you're looking for help in just about any IT topic. There is also PHP documentation and Mysql documentation.

Then write it yourself (TINAT, This Is Not A Troll). It will take you at most a day to do and you'll a) have something that completely fits your needs, and b) can be modified in house if need be (reduced turn around on maintenance). Literally, this is like a two-table database in MySQL/Postgresql/Access, maybe three or four ASP/PHP/perl cgi/whatever pages. This is the solution we use here @ work and it does the job fine. There is a two part article on how to do exactly this with PHP on devshed. Heck, if you have a windows 98 machine sitting on the secretary's desk you can install the PWS (IIS's minime) package off the win98 disk, use ASP (for the love of god use jscript though, vbscript is unmaintainable garbage), and use Access as the datastore. All of this software you probably already have. If you want to follow the article on devshed, PHP4 works OK (cgi and isapi mode) with PWS. MySQL even works "OK" on win9x... Of course, if your office has hundreds of workers, you'll want to use something a lot more robust (you didn't say), but if you only have like 10 folks...

Then write it yourself (TINAT, This Is Not A Troll). It will take you at most a day to do and you'll a) have something that completely fits your needs, and b) can be modified in house if need be (reduced turn around on maintenance). Literally, this is like a two-table database in MySQL/Postgresql/Access, maybe three or four ASP/PHP/perl cgi/whatever pages. This is the solution we use here @ work and it does the job fine. There is a two part article on how to do exactly this with PHP on devshed. Heck, if you have a windows 98 machine sitting on the secretary's desk you can install the PWS (IIS's minime) package off the win98 disk, use ASP (for the love of god use jscript though, vbscript is unmaintainable garbage), and use Access as the datastore. All of this software you probably already have. If you want to follow the article on devshed, PHP4 works OK (cgi and isapi mode) with PWS. MySQL even works "OK" on win9x... Of course, if your office has hundreds of workers, you'll want to use something a lot more robust (you didn't say), but if you only have like 10 folks...

Then write it yourself (TINAT, This Is Not A Troll). It will take you at most a day to do and you'll a) have something that completely fits your needs, and b) can be modified in house if need be (reduced turn around on maintenance). Literally, this is like a two-table database in MySQL/Postgresql/Access, maybe three or four ASP/PHP/perl cgi/whatever pages. This is the solution we use here @ work and it does the job fine. There is a two part article on how to do exactly this with PHP on devshed. Heck, if you have a windows 98 machine sitting on the secretary's desk you can install the PWS (IIS's minime) package off the win98 disk, use ASP (for the love of god use jscript though, vbscript is unmaintainable garbage), and use Access as the datastore. All of this software you probably already have. If you want to follow the article on devshed, PHP4 works OK (cgi and isapi mode) with PWS. MySQL even works "OK" on win9x... Of course, if your office has hundreds of workers, you'll want to use something a lot more robust (you didn't say), but if you only have like 10 folks...

There's an article (not necessarily good, but useful) over at DevShed that explains how to get MyODBC to work with MySQL and then link a Microsoft system running MS Access to it.

Here it is.

There's an article (not necessarily good, but useful) over at DevShed that explains how to get MyODBC to work with MySQL and then link a Microsoft system running MS Access to it.

Here it is.

http://www.devshed.com/Server_Side/MySQL/ODBC/
"Learn it from start to finish. Installing MyODBC, creating a new data source through the ODBC Data Source Administrator, linking a MySQL database into a new MS Access database, and finally updating the MySQL database through an MS Access GUI."

Enjoy

A site I like is www.devshed.com.

It focuses on web programming, so you won't find C or anything, but you'll find tons of stuff for my new favourite languages, PHP and Python.

Besides, posting this will nullify my accidental moderation up of a seemingly innocuous link that displayed the disgusting picture favoured by the trolls around here. I even hovered over the link to check first. I can't believe someone registered "techiescripts.com" for that purpose...

this article might give some insight
As you mentioned ReiserFS is quick with small files, which pretty much is most web content.
Also just look on the ReiserFS main page look at the middle logo "Squid cache optimization sponsored by ThresholdNetworks" I'm absolutely no expert on file system concepts so don't take me too seriously.

oops.... didn't submit that in HTML... Here's the link to that story for anyone interested: Open Source - On Why Not Sorry `bout that.

Devshed gives a pretty good explanation of table joins in one of its tutorials. Through the use of examples, I've come to learn that left-joins are god.

DevShed explains the left-join

Oops.. forgot the link to the Apache Jserv intro:

http://www.devshed.com/Server_Side/JServ/

We developed our sites in PHP3 with MySQL on FreeBSD, and we're very happy with them. However, we've recently been playing with a couple other tools that have really piqued our interest.

ZOPE: Very nice development interface, easy to add functionality using python, XML support, good cross-platform ability. The object-based development platform takes a little getting used to, but is extremely powerful and convenient.

See An Introduction to Zope for a very good overview.

PHP: Can do just about anything. Great database support. We've had no performance problems due to php at all. Run it as an apache module, of course. I have not used it much on Windows, but PHP4 promises to have excellent Windows support.

We have a number of articles, tutorials and docs about PHP at DevShed.

APACHE JSERV: Efficient, powerful, mature. Apache talks to "Servlets" that do most of the work. The servlets stay in memory, no new processes are forked. Multiple servlets may be used, I believe across multiple servers if necessary. Session management is included. It's all Java. Apache Jakarta will also include Java Server Pages (JSP), a strong competitor to PHP and ASP.

ROXEN: Similar to PHP, written in Pike, a C-like object oriented language. Easy separation of layout and content, easy database integration, very efficient. This one includes its own multipurpose server (web/proxy/ssl/ftp).
See Introduction to Roxen by Kai Voigt for more information.

We're still sticking with PHP for now, but looking most seriously at Jserv for the future.
Our #1 qualifier:

OPEN SOURCE - all of the above solutions are!

We developed our sites in PHP3 with MySQL on FreeBSD, and we're very happy with them. However, we've recently been playing with a couple other tools that have really piqued our interest.

ZOPE: Very nice development interface, easy to add functionality using python, XML support, good cross-platform ability. The object-based development platform takes a little getting used to, but is extremely powerful and convenient.

See An Introduction to Zope for a very good overview.

PHP: Can do just about anything. Great database support. We've had no performance problems due to php at all. Run it as an apache module, of course. I have not used it much on Windows, but PHP4 promises to have excellent Windows support.

We have a number of articles, tutorials and docs about PHP at DevShed.

APACHE JSERV: Efficient, powerful, mature. Apache talks to "Servlets" that do most of the work. The servlets stay in memory, no new processes are forked. Multiple servlets may be used, I believe across multiple servers if necessary. Session management is included. It's all Java. Apache Jakarta will also include Java Server Pages (JSP), a strong competitor to PHP and ASP.

ROXEN: Similar to PHP, written in Pike, a C-like object oriented language. Easy separation of layout and content, easy database integration, very efficient. This one includes its own multipurpose server (web/proxy/ssl/ftp).
See Introduction to Roxen by Kai Voigt for more information.

We're still sticking with PHP for now, but looking most seriously at Jserv for the future.
Our #1 qualifier:

OPEN SOURCE - all of the above solutions are!

We developed our sites in PHP3 with MySQL on FreeBSD, and we're very happy with them. However, we've recently been playing with a couple other tools that have really piqued our interest.

ZOPE: Very nice development interface, easy to add functionality using python, XML support, good cross-platform ability. The object-based development platform takes a little getting used to, but is extremely powerful and convenient.

See An Introduction to Zope for a very good overview.

PHP: Can do just about anything. Great database support. We've had no performance problems due to php at all. Run it as an apache module, of course. I have not used it much on Windows, but PHP4 promises to have excellent Windows support.

We have a number of articles, tutorials and docs about PHP at DevShed.

APACHE JSERV: Efficient, powerful, mature. Apache talks to "Servlets" that do most of the work. The servlets stay in memory, no new processes are forked. Multiple servlets may be used, I believe across multiple servers if necessary. Session management is included. It's all Java. Apache Jakarta will also include Java Server Pages (JSP), a strong competitor to PHP and ASP.

ROXEN: Similar to PHP, written in Pike, a C-like object oriented language. Easy separation of layout and content, easy database integration, very efficient. This one includes its own multipurpose server (web/proxy/ssl/ftp).
See Introduction to Roxen by Kai Voigt for more information.

We're still sticking with PHP for now, but looking most seriously at Jserv for the future.
Our #1 qualifier:

OPEN SOURCE - all of the above solutions are!

http://www.devshed.com/Server_Side/Z ope/Intro/