WWW SQL Designer - default
http://ondras.zarovi.cz/sql/demo/?keyword=default

Visual relational database designer, done entirely in <canvas> and javascript. Rather swanky-looking.

This tool allows you to draw and create database schemas (E-R diagrams) directly in browser, without the need for any external programs (flash)

これは次回使いたい。

vie guthrie

Listable, create and share lists with JSON, SQL, and plaintext output

via guthrie

listable, list making, serving site

having so much fun with this already (via sccottt)

login tutorial

php做简单登陆系统

สอนทำระบบล็อกอิน

User Accounts

How to Paginate Data with PHP

from NETTUTS

An explanation of how to paginate data using PHP -- code is included.

「無言語化: 機能を言葉で説明しない」これ、素敵

事例

* 質を高める ユーザに狙った価値を提供できているのかテストするためのもの ユーザテストのときには質問には答えない、質問が出るインターフェースは失敗 顔マーケティング ライバルに勝てる「ウリ」

Ask SM sobre PHP: Validacion de formularios, MySQLtoXML y mas ...

smashingmagazine.com: form validation & converting mysql to xml

tuning tips

DBのチューニング

Looks hot. Hopefully less crash prone than MySQL Administrator. Will try.

MySQL Database editing app for OS X

Interesting article about MySQL scalability problems.

昨日のの邦訳

"Database sharding is the process of splitting up a database across multiple machines to improve the scalability of an application. The justification for database sharding is that after a certain scale point it is cheaper and more feasible to scale a site horizontally by adding more machines than to grow it vertically by adding beefier servers."

SELECT Name, Address FROM Customers WHERE CustomerID= ?", conn);

よいまとめ

Andrew is the original developer of MySQL & has recently left Sun.

The reason I am asking you to be very cautious about MySQL 5.1 is that there are still many known and unknown fatal bugs in the new features that are still not addressed.

Everything You Need to Get Started With MySQL - NETTUTS

ACL

おまけ： Sharding

Web屋のネタ帳さんの記事では16のポイントが紹介されているが、漢（オトコ）のコンピュータ道の記事は10の方法だったのであと6つ足りない。オトコは数で勝負！！というわけで今日はネタを振り絞ってさらに7つのMySQL高速化テクニックを紹介しよう。

さらにMySQLを高速化する7つの方法

Free downloadable IP address to long/lat SQL database

free IP address geolocation SQL database

IP Location tools

facebook structure

Zur Spezifikation der Ausschreibung hinzufügen

For example, if you have an ip of 74.125.45.100 (google.com)

All great websites have a great server behind them. In this tutorial, I'll show you how to set up a dedicated web server (with Apache, MySQL, and PHP) using that old computer you have lying around the house and some free software.

When you think about it, a database dump is just SQL code, so why not manage it the same way you manage the rest of your code — in a source code manager? Setting such a scheme up is dead simple. On your production server, with git installed:

A while back, I read a tutorial by Dan Wellman, which described the steps required to produce a neat Tag-Cloud. Dan's example largely relied on the jQuery framework to request data and construct the user interface elements. I decided to write his tutorial all over again with the two exceptions of using GWT instead of jQuery, and a different method of choosing font size variations. In case you don't know what Tag-Clouds are and what purpose they serve, briefly, a Tag-Cloud is a form of visualizing the difference in importance or activeness of some predefined categories based on how large they appear in the cloud. Tag Cloud We are going to use the latest version of GWT (currently 1.5) and work with MySQL and PHP as our back-end to request the JSON data. Similar to Dan's tutorial, I too, assume that you already are familiar with inserting into a database. The PHP code in this article will merely cover how to query data from the database and send back the result in JSON format. You shoul

http://net.tutsplus.com/tutorials/javascript-ajax/building-a-tag-cloud-using-the-google-web-toolkit/

Login

In today's video tutorial, we'll be building a login system with PHP and MYSQL. Many, many features will be covered; including MySqli, Prepared Statements,

Twitter Emulation Using MooTools 1.2 and PHP - Nettuts+

Crear twitter con mootools y php

preventDefault();

mysqlの限界値。こういうの調べるのに時間かかったりするのでたいへんありがたや～。

どこまで出来るか?!やれるところまでやってやるぜ!!と、威勢が良いのは若い間だけの話。オトナのオトコは、攻めるときはとことん攻めるが自らの限界もわきまえて賢く振る舞うのがスマートってものである。というわけで、今日はMySQLのいろいろな限界についてまとめてみる。皆さんも是非MySQLの限界を知り、MySQLをもっとスマートに使って頂きたい。

ur own server and there are no ongoing monthly costs.

a basic one about optimizing database query execution time

Indexing the Web

Complete (City)

The SQL database behind ipinfodb.com is offered for free. We offer the database in different formats (SQL, CSV), city or country precision, 3 or 4 IP digits precision and data in single or multiple tables. Available information in the database : ISO country code, country name, FIPS region code, region name, city, zipcode, latitude, longitude and GMT/DST timezone. The database is updated during the first week of each month.

Backup2Mail is mini PHP application that creates regular backups of your MySQL database and sends it to configurable e-mail address. The whole process is scheduled with a help of Cron, a Unix program that runs programs at scheduled times.

Send MySQL database backup to your mailbox

http://www.backup2mail.com/

SQL Databases Are An Overapplied Solution (And What To Use Instead)

No, not SHARED lessons, I mean SHARD lessons. I have to admit that until about a year ago I didn't really know the term shards in relation to databases. Now don't confuse that with not understanding how databases can be horizontally scaled. I was introduced to that concept and helped to define the various ways it can be done but we just called it splits. Regardless of what you call it, there are some interesting challenges that are introduced. The well known challenges of consistency are discussed ad nauseam, even by me, so I'm not going there with this article. But besides that, there are some other lessons to learn when applying the pattern to your data.

Worth reading just for the section on intelligently designing shard counts. Great discussion on picking counts that smooth your cost step function

An Architectural Hybrid of MapReduce and DBMS Technologies for Analytical Workloads.

HadoopDB is: 1. A hybrid of DBMS and MapReduce technologies that targets analytical workloads 2. Designed to run on a shared-nothing cluster of commodity machines, or in the cloud 3. An attempt to fill the gap in the market for a free and open source parallel DBMS 4. Much more scalable than currently available parallel database systems and DBMS/MapReduce hybrid systems. 5. As scalable as Hadoop, while achieving superior performance on structured data analysis workloads

vielleicht zur ergänzung fürs swr3 infoportal? nur so ein gedanke... ausprobiert hab ichs auch noch nicht

Una espacie de delicious de uso casero. Muy interesante para etiquetar la noticias de los periódicos ó cosas por el estilo

Free PHP knowledge base script

Professional knowledge base script that allows you to create your own documentation.

68k php knowledge base software

Datenbank zum Ablegen von Wissen, ähnlich zu Wikis

MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries. Here are very useful tips for all mysql DBA’s, Developers these tips are noted from MySQL Camp 2006 suggested by mysql community experts.

# # Don’t use DISTINCT when you have or could use GROUP BY

Don’t use deprecated features

i

30 Essential Web Developer Cheat Sheets

The list of skills a given web developer must possess is growing everyday. With the massive growth of web technologies, comes the demand for developers with a wide skill set. A useful tool in any developers tool box can be the well known 'cheat sheet'. Today, we will have a look at 30 essential web developer cheat sheets, ranging from MySQL to Photoshop.

Shown below is a (single query) SQL-generated pie chart. I will walk through the steps towards making this happen, and conclude with what, I hope you’ll agree, are real-world, useful usage samples.

ASCII art via SQL

uery) SQL-generated pie chart. I will walk through the steps towards making this happen, and conclude with what, I hope you’ll agree, are real-world, useful usage samples. +-------------------------------------------------------

Pie Chart in SQL

create an ascii art pie chart with a single sql query

SQL でアスキーアート的なもの。

url shortner

I recently purchased shaun.in (ooh, dynamically generated SVG). Because the domain itself is so short (compared to the verbose shauninman.com) and in light of the current volatility exhibited by third-party url shorteners, I thought I would try my hand at rolling my own shortener. A few people have inquired about it so here we are.

Lessn is an extremely simple, personal url shortener written in PHP with MySQL and mod_rewrite.

Free and simple URL shortener software.

Single-file PHP MySQL database administration tool

Adminer (formerly phpMinAdmin) is a full-featured MySQL management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server.

an alternative to phpMyAdmin

MySQLで索引を使っていないクエリーをログを調べずに見つける方法

Here is a quick rundown of common tasks you might have to do to migrate properly.

Good list

list of many database softwares and categorized

Liste de logiciels de bases de données classés par modèle de gestion de l'information (relationnel, XML, RDF...)

jCore is a Multi Site web Content Management System build especially for webmasters (using the well known LAMP environment) who have to maintain multiple websites for their clients and they would like to keep the source codes up to date and easily fix bugs for all clients at once.

answer is 3TB database???

"The fundamental problem is endemic to the relational database mindset, which places the burden of computation on reads rather than writes."

Wow, cassandra uses a lot of disk space. Trade offs!

These are instructions for compiling and installing 64-bit Ruby, Rubygems, and Ruby on Rails on Mac OS X 10.6, Snow Leopard.

sudo gem install mysql -- --with-mysql-dir=/usr/local/mysql

Snow Leopard compatible instructions for compiling ruby

As a Web developer it's always a good idea to know what the current practices are in the industry even if they seem a bit too crazy to adopt…yet.

bit on why non-SQL dbs are used in social networking sites

Form di registrazione al sito

サブクエリ、あんまりよくない理由

というわけでMySQLによるサブクエリの処理について見てきたが、きちんと気をつけて使えばサブクエリも高速に実行される。もちろんJOINに書き換えた方が速いのは言うまでもないが、SQL文のメンテナンスし易さなどを考えるとサブクエリで処理を書きたい！という人も居るのではないだろうか。そんな方は次の事に気をつけてサブクエリを使って頂きたい。 * サブクエリの種類 * 外部クエリとサブクエリの評価の順序 * 外部クエリにおいてフェッチされる行数 * サブクエリで利用されるインデックス * テンポラリテーブルのサイズ

"Graphs are ubiquitous. Social or P2P networks, thesauri, route planning systems, recommendation systems, collaborative filtering, even the World Wide Web itself is ultimately a graph! Given their importance, it’s surely worth spending some time in studying some algorithms and models to represent and work with them effectively. In this short article, we’re going to see how we can store a graph in a DBMS. Given how much attention my talk about storing a tree data structure in the db received, it’s probably going to be interesting to many. Unfortunately, the Tree models/techniques do not apply to generic graphs, so let’s discover how we can deal with them."

Great presentation about good SQL practice.

interesting but it's a slideshow rather than an article

check later

login system

Today we are making a cool & simple login / registration system. It will give you the ability to easily create a member-only area on your site and provide an easy registration process. It is going to be PHP driven and store all the registrations into a MySQL database. To add the needed flair, we are using the amazing sliding jQuery panel, developed by Web-kreation.

とても勉強になる。

kommentar von o'reilly "Giving modifications back to the Drupal community is the next breakthrough announcement that I'll be looking for."

Yesterday, the new media team at the White House announced via the Associated Press that whitehouse.gov is now running on Drupal, the open source content management system. That Drupal implementation is in turn running on a Red Hat Linux system with Apache, MySQL and the rest of the LAMP stack. Apache Solr is the new White House search engine.

This looks great. Object Oriented PHP 5, MySQL, easy to set up and customize. This should be a good solution for a quick project that needs user login functionality.

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you up to focus on your applications and business. Amazon RDS gives you access to the full capabilities of a familiar MySQL database. This means the code, applications, and tools you already use today with your existing MySQL databases work seamlessly with Amazon RDS. Amazon RDS automatically patches the database software and backs up your database, storing the backups for a user-defined retention period. You also benefit from the flexibility of being able to scale the compute resources or storage capacity associated with your relational database instance via a single API call. As with all Amazon Web Services, there are no up-front investments required, and you pay only for the resources you use.

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you up to focus on your applications and business.MySQL

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you up to focus on your applications and business. Amazon RDS gives you access to the full capabilities of a familiar MySQL database.

mysqlのレプリケーションを用いた構成について書いたblog記事。まだきちんと読んでいない。 フェールオーバー時のデータの完全性を保証しない構成。 想定する運用フローが書いてあるので、自分で考えるときの参考にする

MySQLのInnnoDB、MyISAMの利点・欠点がまとめられている。参考になります。

自分は、特別な事情が無い限り、5.1最新版に含まれるInnoDB Pluginを勧めています。

A great tutorial using CodeIgniter and jQuery to recreate the live search feature on MT's knowledgebase.

Programming, Designing and Blogging

: Collection of php classes and functions sto

[vía @basilio] # Learn the difference between good and bad code. read more # Stick to coding standards, it will make it easier for you to understand other people’s code and other people will be able to understand yours. read more

PHP programming tips and tricks

"Sharding kills most of the value of a relational database."

sql database db

innodbの書き込み速度を上げるtipsと、その他設定について

sudo hdparm -W 0 /dev/sda

Is real-time query performance and diagnostics tool for the MySQL database server.

Java desktop graphical MySQLprofiler. Free version.

Real-time query performance and diagnostics tool for the MySQL database server.

4 tips buenos para mejorar el desempeño de MySQL.

MySQL configuration variables that have defaults which have proven to be problematic in a high-volume production environment

Django with Mysql and Apache

keepalived --vrrp で、マルチマスターフェイルオーバーする

JOINs em Mysql

5. Index and Use Same Column Types for Joins

** Posted using Viigo: Mobile RSS, Sports, Current Events and more **

20 Best practices

Database operations often tend to be the main bottleneck for most web applications today. It's not only the DBA's (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. Here are some MySQL optimization techniques for programmers.

MySQLの負荷テストに便利らしい。

with

2年に1回起きる可能性があるわけで、確かに何か対策した方がよいですね。 しかしケーブルや機材を取り替えて推奨値以上の環境を用意すれば2000万年に1回。10GbEthernetでも200万年に1回の確率ですね・・・それでも対策しないよりも対策した方がよいですが・・・ Okunoさんはバイナリログがネットワークによって化けた経験がおありなんですよね？

"1. マルチマスターレプリケーションを利用しない 非常によくある誤解なのだが、HAにしたいからといってマルチマスター構成にしているユーザをたまに見かける。マルチマスターとは２台のMySQLサーバで構成するトポロジのことで、２つのサーバが互いに相手のマスターかつスレーブとなりレプリケーションを行う。マルチマスターは両方のホストで更新が可能なのだが、片方のサーバ行われた更新は非同期でもう一方のサーバへ適用されるため、更新を行っている方のサーバがクラッシュした場合には更新が失われる可能性がある。"

よくある構成っちゃ、よくある構成。MySQL ClusterとかMySQL Proxyとかの完成度があがっていくとこの部分の構成がもっとシンプルかつ強いシステムになっていくのかも

「dual master + ソフトウエアロードバランサ + Nagios」「masterサーバーに障害があった場合には、(Nagios のイベントハンドラで)それに直結する slave のヘルスチェック用ポートを閉じる」

事例

dual master, ソフトウェアロードバランサ, 仮想DNS, gethostbyname書き換え, masterが片方落ちたら直下のslaveもnagiosのイベントハンドラで落として一貫性保つ

"Common blunders of SQL database design, queries, and software development. Presented as a tutorial at the MySQL Conference & Expo 2009."

none

A presentation about modelling trees relationally and storing them in an SQL database.

Storing tree structures in a bi-dimensional table has always been problematic. The simplest tree models are usually quit

trees in database

how to store tree structure on RDB

階層構造

*****

One in particular now has grown out of hand so bad that we've decided to start from scratch for a whole new version. Why? Lets say you have 3000+ php files, and your boss says "Hrm, we're seeing some problems with performance. Can you display at the bottom of each page the # of queries you use on that page?" If you coded your entire project like the example above, you would be totally screwed. You would have to find each and every mysql_query() and add some counter at the end. It would be a managing Nightmare. So how cold you solve this problem?

I've been a big proponent of NoSQL for a while. I have played with just about all of the new generation of data stores. We almost got cassandra running in production once, and we've been running mongodb in production for about six months now. But, here's the thing: as awesome as these new dbs are, they're still young. Our app generates a ton of data and gets pretty serious traffic. So, we started hitting walls quickly. To make a long story short, we decided to fall back to MySQL. It's battle hardened. We know its production characteristics and limitations. Backups are a science. We know we can count on it. But, we have a lot of data, and adding fields and indexes was starting to get painful. Flexible schemas are one of the things that attracted me to NoSQL in the first place. Then, I remembered this article about How FriendFeed uses MySQL to store schema-less data. So, I decided to implement the system they describe in the article. Since we put Friendly in to production, we've seen

Friendly makes MySQL look like a document store. When you save an object, it seralizes all of its attributes to JSON and stores them in a single field. To query your data, Friendly creates and maintains indexes in separate tables. It even has write-through and read-through caching built right in.

Introducing Friendly: NoSQL With MySQL in Ruby Dec 16 2009 I've been a big proponent of NoSQL for a while. I have played with just about all of the new generation of data stores. We almost got cassandra running in production once, and we've been running mongodb in production for about six months now.

Muy, interesante, recomendaciones para recuperar información de mysql

WordPress is driven by a MySQL database. This is something active WordPress users would know. However, if you only just read about it here from us, here’s what you should know. MySQL is a free relational database management system

A paginated display is one of the top optimization scenarios we see in the real world. Search results pages, leaderboards, and most-popular lists are good examples. You know the design pattern: display 20 results in some most-relevant order. Show a "next" and "previous" link. And usually, show how many items are in the whole list and how many pages of results there are. Rendering such a display can consume more resources than the entire rest of the site! As an example, I'm looking at slow log analysis results (with our microslow patches, set to log all queries) for one client; the slow log contains 6300 seconds' worth of queries, and the two main queries for the paginated display consumed 2850 and 380 seconds, respectively.

Rendering such a display can consume more resources than the entire rest of the site!

A paginated display is one of the top optimization scenarios we see in the real world. Search results pages, leaderboards, and most-popular lists are good examples.

Perl script for reporting back on your MySQL config.

Debugging and Tuning MySQL performance

Handy script to gather suggestions on mysql tuning

Great comment on using XFS and snapshots to reduce downtime.

sun main page

this is the sun oracle merger from the sun page.

On April 20, 2009, Sun and Oracle announced a definitive agreement under which Oracle will acquire Sun common stock for $9.50 per share in cash. The transaction is valued at approximately $7.4 billion, or $5.6 billion net of Sun's cash and debt. The proposed transaction is subject to Sun stockholder approval, certain regulatory approvals and customary closing conditions. Until the deal closes, each company will continue to operate independently, and it is business as usual.

RT @monkchips: Oracle bought Sun. i think IBM kind of fucked up. http://tinyurl.com/cgavxo &lt;-More like Oracle bought mySQL and Sun came with [from http://twitter.com/danphilpott/statuses/1565134176]

Nice post on how to install a local server for testing purposes.

http://localhost/wp/

I guess the conclusion is that there’s no use in preempting the technological progress of tomorrow. Machines will get faster and cheaper all the time, but you’ll still only have the same limited programming resources that you had yesterday. If you can spend them on adding stuff that users care about instead of prematurely optimizing for the future, you stand a better chance of being in business when that tomorrow finally rolls around.

From 37signals

VerkkoStadi Technologies is looking for a Hardcore PHP Developer. See more on the Job Board.

InnoDBは行ロックに対応。6000万レコード。。。

Web アプリケーションとは切っても切れないセッション機構。DB ベースでセッション管理を行なって得られた知見と、それを元に考察した結果をまとめてみます。

Common MySQL Queries

Common MySQL Queries (Extending Chapter 9 of Get it Done with MySQL 5&6)

Common Queries,Common MySQL Queries,Common SQL Queries

les SQL de base pour gérer son blog sur wordpress

Même si il ya beaucoup de choses que vous pouvez faire dans WordPress, parfois vous avez besoin d'une solution rapide pour corriger un problème spécifique. Dans ces cas, travailler directement sur la base de données peut être salvateur. Voici donc 10 requêtes SQL extrêmement utiles pour WordPress.

and it's on track to become the open source world's canonical answer to the question of text search. MySQL and Solr, the two popular solutions, are showing their age. MySQL introduced full-text search in late 2000 as a way to more intelligently search blobs of text stored in databases. You can work a full-text clause into a query, and MySQL will rank the result rows by how relevant it thinks they are to the query. MySQL uses textbook search algorithms and doesn't allow for a lot of relevance tuning. It's like a drawing from a five year old: The heart is in the right place, but everybody knows that kids suck at drawing. Implementation details aside, MySQL still suffers from scalability problems. Having ignored the trend of chip manufacturers to build multiple cores into CPUs, hoping that this unpleasant trend that required them to actually think about multi-threading would just blow over sooner or later, MySQL's ability to handle parallelism is, well, see the five year old's drawing.

Sphinx can index 10 megabytes of data per second and can search up to 100 gigabytes of text on a single processor. It also supports multi-machine distributed searching, as in the case of Craigslist.

SQL optimization

10 sql tips to speed up your database http://bit.ly/9uIi6k #sql

データベースパフォーマンスアップの教科書 基本原理編

どこの現場に行っても正解を導く方程式は一緒なので応用が利く Oracle、SQLServer、MySQLと色々なDBのチューニングをしてきましたが、 どれもRDBの理論に基いているので基本原理を知ればチューニングは可能なはず インデックススキャンの種類や、実行計画の読み方もわかりやすく詳しい

I've worked with expensive SQL Server and Oracle setups for most of my career. I've defended them viciously against all comers and contrarians. I've participated in late-night guerilla flame wars and drunken bar brawls. And I've sought out with relentless tunnel vision those pieces of propaganda which support my foregone conclusion: that SQL Server and/or Oracle are (or were) the best choices for the organization. I used to be a commercial database advocate. These databases have put food on my table for a dozen years, you see. I am (or was) what you might call an entrenched practicioner, not necessarily an expert, but a practicioner. And in the manner of entrenched practicioners around the world, I've treated you heretics with the sadistic undercutting and poisonous rancor you've deserved! "MySQL?" I would sneer. "PostgreSQL? Thanks, but this a serious project. We need a database we can depend on." Ahem.

googled "why pay for commercial database" and found this among other articles

Are Commercial Databases Worth It? http://bit.ly/Du96H (via @newsycombinator) [from http://twitter.com/tadej/statuses/1664387681]

Se cuestiona la idoneidad de escoger una BD comercial com Oracle o SQL Server frente a sus alternativas Open Source.

Wow this is really neat

It will display the number of visitors, currently viewing your site, and thanks to Hostip’s free IP to location API, it will even be able to detect the country your visitors are from and display it in a slide out panel.

“Who Is Online” Widget With PHP, MySQL & jQuery – Tutorialzine

# # Scaling practices turn a relational database into a non-relational database. To scale at Digg they followed a set of practices very similar to those used at eBay. No joins, no foreign key constraints (to scale writes), primary key look-ups only, limited range queries, and joins were done in memory. When implementing the comment feature a 4,000 percent increase in performance was created by sorting in PHP instead of MySQL. All this effort required to make a relational database scale basically meant you were using a non-relational database anyway. So why not just use a non-relational database from the start?

As Digg started out with a MySQL oriented architecture and has recently been moving full speed to Cassandra, his observations on some of their lessons learned and the motivation for the move are especially valuable. Here are some of the key takeaways you find useful:

RT @Sebdz: RT: @programmateur: Digg: 4000 % performance increase by sorting in PHP rather than MySQL (via @mrboo) - http://bit.ly/ckma10

♻ @n1k0: "Scaling practices turn a relational database into a non-relational database" http://n1k.li/4v (via @nsilberman)

Typically for relatively static data sets, relatively low query volumes, and relatively high latency requirements.

In this tutorial we are making a simple AJAX-ed Todo List App, with PHP, MySQL and jQuery. In the process we are going to demonstrate PHP’s OOP capabilities, play with jQuery UI and implement some nice AJAX functionality. For a better understanding of the steps of this tutorial, you an go ahead and download the demo archive available from the button above.

These are all mysql oriented, but it sure seems like there are some fantastic principles to be pulling from here. Ex "covering indexes; orders-of-magnitude improvements." Or one on optimizing disk i/o.

Slides from a great variety of sessions @ Percona Performance Conference 2009 (April)

slides of the conference are available onliny

バッチ

Zajimave tipy pro webvyvoj - jquery, printstyle, geo vyhledavani...

PayPal provides numerous APIs and integration options for third-party developers. One of these is the Donation button, which you can generate straight from PayPal’s site and include directly into your pages. Conversion rate for these buttons is typically minimal, but the right incentive can make a big difference. The idea is to have a dedicated Donation Center. This is a place, where you get to see what a difference your donation would make, and a list of people who have already donated. After choosing the amount you wish to donate and clicking the button, you are redirected to paypal.com to complete the transaction. After this is done, you are redirected back to the donation center where you can fill a form and get included in the official Donor List.

PHP

Watch live mysql sql statements with dtrace

helpful

DESIGN

tons of good ajax techniques...

How to do jQuery, Ajax, PHP and MySQL Projects. Topics focus on Programming, Jquery, Ajax, PHP, Demos, Web Design, Javascript and MySQL

A Collection of jQuery and Ajax Tutorials with live demos, tutorials posted on 9lessons blog.

Many PHP programmers learned how to access databases by using either the mysql or mysqli extensions. Since PHP 5.1, there’s been a better way. PHP Data Objects (PDO) provide methods for prepared statements and working with objects that will make you far more productive!

This is an eazy to learn tutorial for PDO.

Many PHP programmers learned how to access databases by using either the mysql or mysqli extensions. Since PHP 5.1, there's been a better way. PHP Data Objects

ripe for SQL Injection!

Bullet / SlimScrooge/ Query Reviewer / Rails Indexes / Ambitious Query Indexer

eCart - Powerful open source eCommerce platform - http://www.ecartcommerce.com/

ecard is a powerfull ecommerce platfom and a top rated magento alternative

Tiene buena pinta

eCart - Powerful open source eCommerce platform - http://www.ecartcommerce.com/

又拍网和大多数Web2.0站点一样，构建于大量开源软件之上，包括MySQL、PHP、nginx、Python、memcached、redis、Solr、Hadoop和RabbitMQ等等。又拍网的服务器端开发语言主要是PHP和Python，其中PHP用于编写Web逻辑（通过HTTP和用户直接打交道）， 而Python则主要用于开发内部服务和后台任务。在客户端则使用了大量的Javascript， 这里要感谢一下MooTools这个JS框架，它使得我们很享受前端开发过程。 另外，我们把图片处理过程从PHP进程里独立出来变成一个服务。这个服务基于nginx，但是是作为nginx的一个模块而开放REST API。

B上我们都建立了shard_001和shard_002两个逻辑数据库， Node-A上的shard_001和Node-B上的shard_001组成一个Shard，而同一时间只有一个逻辑数据库处于Active状态

又拍网和大多数Web2.0站点一样，构建于大量开源软件之上，包括MySQL、PHP、nginx、Python、memcached、redis、Solr、Hadoop和RabbitMQ等等。又拍网的服务器端开发语言主要是PHP和Python，其中PHP用于编写Web逻辑（通过HTTP和用户直接打交道）， 而Python则主要用于开发内部服务和后台任务。在客户端则使用了大量的Javascript， 这里要感谢一下MooTools这个JS框架，它使得我们很享受前端开发过程。 另外，我们把图片处理过程从PHP进程里独立出来变成一个服务。这个服务基于nginx，但是是作为nginx的一个模块而开放REST API。

B上我们都建立了shard_001和shard_002两个逻辑数据库， Node-A上的shard_001和Node-B上的shard_001组成一个Shard，而同一时间只有一个逻辑数据库处于Active状态

These days its pretty standard to require support for multiple languages and special characters on your website. But it’s still terribly easy to trip up and make mistakes, usually indicated by weird characters popping up across your web content. Here’s a few tips on how to sort out your character encoding.

These days its pretty standard to require support for multiple languages and special characters on your website. But it’s still terribly easy to trip up and make mistakes, usually indicated by weird characters popping up across your web content. Here’s a few tips on how to sort out your character encoding.

mysql触发器介绍