WWW SQL Designer - default
This tool allows you to draw and create database schemas (E-R diagrams) directly in browser, without the need for any external programs (flash)ブラウザ上でさくさくデータベースの設計ができる『WWW SQL Designer』がすごすぎる - IDEA*IDEA ～ 百式管理人のライフハックブログ ～
Listable, create and share lists with JSON, SQL, and plaintext output
listable, list making, serving site
having so much fun with this already (via sccottt)How to Build a Login System for a Simple Website - NETTUTS
User Accounts32 Tips To Speed Up Your MySQL Queries | AjaxLine
How to Paginate Data with PHP
An explanation of how to paginate data using PHP -- code is included.「クックパッド」の裏側にいってきた
* 質を高める ユーザに狙った価値を提供できているのかテストするためのもの ユーザテストのときには質問には答えない、質問が出るインターフェースは失敗 顔マーケティング ライバルに勝てる「ウリ」Ask SM [PHP]: Form Validation, Converting MySQL to XML | Developer's Toolbox | Smashing Magazine
Ask SM sobre PHP: Validacion de formularios, MySQLtoXML y mas ...
smashingmagazine.com: form validation & converting mysql to xml漢(オトコ)のコンピュータ道: MySQLを高速化する10の方法
DBのチューニングAraelium Group : Querious - MySQL Database Tool
Looks hot. Hopefully less crash prone than MySQL Administrator. Will try.
MySQL Database editing app for OS XHow FriendFeed uses MySQL to store schema-less data - Bret Taylor's blog
Interesting article about MySQL scalability problems.HowFriendFeedUsesMySqlToStoreSchemaLessData - FriendFeed では MySQL を使いどのようにスキーマレスのデータを保存しているのか
昨日のの邦訳Dare Obasanjo aka Carnage4Life - Building Scalable Databases: Pros and Cons of Various Database Sharding Schemes
"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);Ruby on Rails + MySQL で全文検索 - ドワンゴ 研究開発ブログ
よいまとめMonty says: Oops, we did it again (MySQL 5.1 released as GA with crashing bugs)
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.10 Ways to Automatically & Manually Backup MySQL Database | Noupe
Everything You Need to Get Started With MySQL - NETTUTSIP address geolocation SQL database | Share your knowledge!
さらにMySQLを高速化する7つの方法IP address geolocation SQL database
Free downloadable IP address to long/lat SQL database
free IP address geolocation SQL databaseIP Location tools :: IP Location Tools
IP Location toolsInfoQ: Facebook: Science and the Social Graph
facebook structureMake: Online : Free, unlimited IP address geolocation with MySQL
Zur Spezifikation der Ausschreibung hinzufügen
For example, if you have an ip of 184.108.40.206 (google.com)18 Seriously Helpful Cheat Sheets for Easier Coding | Web Design Ledger
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.漢(オトコ)のコンピュータ道: MySQLのEXPLAINを徹底解説!!
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:Building a Tag-Cloud Using the Google Web Toolkit - Nettuts+
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
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
Twitter Emulation Using MooTools 1.2 and PHP - Nettuts+
Crear twitter con mootools y php
どこまで出来るか?!やれるところまでやってやるぜ!!と、威勢が良いのは若い間だけの話。オトナのオトコは、攻めるときはとことん攻めるが自らの限界もわきまえて賢く振る舞うのがスマートってものである。というわけで、今日はMySQLのいろいろな限界についてまとめてみる。皆さんも是非MySQLの限界を知り、MySQLをもっとスマートに使って頂きたい。Welcome - Perch - A Really Little Content Management System (CMS)
ur own server and there are no ongoing monthly costs.10 Essential SQL Tips for Developers - Nettuts+
a basic one about optimizing database query execution time
Indexing the WebIP address geolocation SQL database :: IPInfoDB
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.Creating an Advanced Password Recovery Utility - Nettuts+
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)
SQL Databases Are An Overapplied Solution (And What To Use Instead)Adding Simplicity - An Engineering Mantra: Shard Lessons
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 function12 Essential Security Tips and Hacks for WordPress
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 workloadsChoosing a non-relational database; why we migrated from MySQL to MongoDB « Boxed Ice Blog
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 WikisRethinkDB - The database for solid state drives.
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 features30 Essential Web Developer Cheat Sheets
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.SQL pie chart | code.openark.org
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 でアスキーアート的なもの。Lessn // ShaunInman.com
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.Adminer
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 phpMyAdminHow to find un-indexed queries in MySQL, without using the log at Xaprb
MySQLで索引を使っていないクエリーをログを調べずに見つける方法Riding Rails: Upgrading to Snow Leopard
Here is a quick rundown of common tasks you might have to do to migrate properly.Using PHP/MySQL with Google Maps - Google Maps API - Google Code
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...)About - jCore - the Webmaster's Multisite CMS
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.Digg the Blog » Blog Archive » Looking to the future with Cassandra
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!Hivelogic - Compiling Ruby, RubyGems, and Rails on Snow Leopard
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 rubyDare Obasanjo aka Carnage4Life - Building Scalable Databases: Denormalization, the NoSQL Movement and Digg
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 sitesMetaSkills.net The Ultimate OS X Snow Leopard Stack For Rails Development - x86_64, MacPorts, Ruby 1.8/1.9, SQL Server, SQLite3, MySQL & More
Form di registrazione al sito漢(オトコ)のコンピュータ道: なぜMySQLのサブクエリは遅いのか。
というわけでMySQLによるサブクエリの処理について見てきたが、きちんと気をつけて使えばサブクエリも高速に実行される。もちろんJOINに書き換えた方が速いのは言うまでもないが、SQL文のメンテナンスし易さなどを考えるとサブクエリで処理を書きたい！という人も居るのではないだろうか。そんな方は次の事に気をつけてサブクエリを使って頂きたい。 * サブクエリの種類 * 外部クエリとサブクエリの評価の順序 * 外部クエリにおいてフェッチされる行数 * サブクエリで利用されるインデックス * テンポラリテーブルのサイズSQL Databases Don't Scale
"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."Sql Antipatterns Strike Back
Great presentation about good SQL practice.
interesting but it's a slideshow rather than an articleMaking A Cool Login System With PHP, MySQL & jQuery – Tutorialzine
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.Facebookが大規模スケーラビリティへの挑戦で学んだこと（前編）～800億枚の写真データとPHPのスケーラビリティ問題 － Publickey
とても勉強になる。Thoughts on the Whitehouse.gov switch to Drupal - O'Reilly Radar
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.UserCake - Opensource PHP user management system
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)
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で、マスタやスレーブが障害停止した場合のリカバリプラン - (ひ)メモ
mysqlのレプリケーションを用いた構成について書いたblog記事。まだきちんと読んでいない。 フェールオーバー時のデータの完全性を保証しない構成。 想定する運用フローが書いてあるので、自分で考えるときの参考にするOpen database life: MyISAMとInnoDBのどちらを使うべきか
自分は、特別な事情が無い限り、5.1最新版に含まれるInnoDB Pluginを勧めています。CodeIgniter and jQuery Real Live Search with Pagination | AEXT.NET
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 stoPHP programming tips and tricks | Marius Stanciu Sergiu's weblog
[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 tricksSQL Databases Don't Scale
"Sharding kills most of the value of a relational database."
sql database db(特にMyISAMを使っていた)ウェブ屋さんがInnoDBを使う場合の設定項目 - kazuhoのメモ置き場
sudo hdparm -W 0 /dev/sdaJet Profiler for MySQL
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.Fixing Poor MySQL Default Configuration Values (by Jeremy Zawodny)
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データベースの基礎を理解しよう！ プログラミング未経験から始めるPHP入門：CodeZine
Django with Mysql and Apache実録、ほぼ無停止なMySQLのフェイルオーバ (動画もあるよ) - (ひ)メモ
keepalived --vrrp で、マルチマスターフェイルオーバーするEXPLAIN EXTENDED: efficient database queries in SQL.
JOINs em MysqljQuery, Ajax, PHP and MySQL Projects.
5. Index and Use Same Column Types for Joins
** Posted using Viigo: Mobile RSS, Sports, Current Events and more **
20 Best practicesTop 20+ MySQL Best Practices - Nettuts+
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.» Scalable Web Applications Programming the new world: Programming your life and the net, one day at a time
MySQLの負荷テストに便利らしい。Snow Leopard Ruby Development Environment Checklist / Gotchas | Ric Roberts: Ruby on Rails developer, Manchester, UK
2年に1回起きる可能性があるわけで、確かに何か対策した方がよいですね。 しかしケーブルや機材を取り替えて推奨値以上の環境を用意すれば2000万年に1回。10GbEthernetでも200万年に1回の確率ですね・・・それでも対策しないよりも対策した方がよいですが・・・ Okunoさんはバイナリログがネットワークによって化けた経験がおありなんですよね？
"1. マルチマスターレプリケーションを利用しない 非常によくある誤解なのだが、HAにしたいからといってマルチマスター構成にしているユーザをたまに見かける。マルチマスターとは２台のMySQLサーバで構成するトポロジのことで、２つのサーバが互いに相手のマスターかつスレーブとなりレプリケーションを行う。マルチマスターは両方のホストで更新が可能なのだが、片方のサーバ行われた更新は非同期でもう一方のサーバへ適用されるため、更新を行っている方のサーバがクラッシュした場合には更新が失われる可能性がある。"Top 20+ MySQL Best Practices | TuVinhSoft .,JSC
よくある構成っちゃ、よくある構成。MySQL ClusterとかMySQL Proxyとかの完成度があがっていくとこの部分の構成がもっとシンプルかつ強いシステムになっていくのかも
「dual master + ソフトウエアロードバランサ + Nagios」「masterサーバーに障害があった場合には、(Nagios のイベントハンドラで)それに直結する slave のヘルスチェック用ポートを閉じる」
dual master, ソフトウェアロードバランサ, 仮想DNS, gethostbyname書き換え, masterが片方落ちたら直下のslaveもnagiosのイベントハンドラで落として一貫性保つRails/jQuery UI sortables with single UPDATE query – The Pug Automatic
"Common blunders of SQL database design, queries, and software development. Presented as a tutorial at the MySQL Conference & Expo 2009."
noneTrees In The Database - Advanced data structures
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 databaseAdvanced Event Timeline With PHP, CSS & jQuery – Tutorialzine
how to store tree structure on RDB
階層構造SQL for Beginners - Nettuts+
*****MySQL utility commands
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?James on Software | Introducing Friendly: NoSQL With MySQL in Ruby
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.9 Tips For Working with MySQL Databases » DevSnippets
Muy, interesante, recomendaciones para recuperar información de mysql13 Useful WordPress SQL Queries You Wish You Knew Earlier | Onextrapixel - Showcasing Web Treats Without Hitch
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 systemFour ways to optimize paginated displays | MySQL Performance Blog
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.Tuning MySQL Performance with MySQLTuner | HowtoForge - Linux Howtos and Tutorials
Perl script for reporting back on your MySQL config.
Debugging and Tuning MySQL performance
Handy script to gather suggestions on mysql tuningBulletproof backups for MySQL | Carsonified
Great comment on using XFS and snapshots to reduce downtime.Sun and Oracle
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 <-More like Oracle bought mySQL and Sun came with [from http://twitter.com/danphilpott/statuses/1565134176]Ask SM: PHP/MySQL Security | How-To | Smashing Magazine
Nice post on how to install a local server for testing purposes.
http://localhost/wp/Mr. Moore gets to punt on sharding - (37signals)
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.
VerkkoStadi Technologies is looking for a Hardcore PHP Developer. See more on the Job Board.データベースを用いたセッションデータ管理について - Slow Dance
Web アプリケーションとは切っても切れないセッション機構。DB ベースでセッション管理を行なって得られた知見と、それを元に考察した結果をまとめてみます。Common Queries Tree
Common MySQL Queries
Common MySQL Queries (Extending Chapter 9 of Get it Done with MySQL 5&6)
Common Queries,Common MySQL Queries,Common SQL QueriesWordPress : 10+ life saving 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.chive - MySQL database management tool
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.PHP Tutorials Examples Introduction to PHP and MySQL
10 sql tips to speed up your database http://bit.ly/9uIi6k #sqlデータベースパフォーマンスに関する、僕が知りうる限り最高の教科書 - 山本大＠クロノスの日記
どこの現場に行っても正解を導く方程式は一緒なので応用が利く Oracle、SQLServer、MySQLと色々なDBのチューニングをしてきましたが、 どれもRDBの理論に基いているので基本原理を知ればチューニングは可能なはず インデックススキャンの種類や、実行計画の読み方もわかりやすく詳しいAre Commercial Databases Worth It? - Coding the Wheel
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.“Who Is Online” Widget With PHP, MySQL & jQuery – Tutorialzine
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 – TutorialzineHigh Scalability - High Scalability - Digg: 4000% Performance Increase by Sorting in PHP Rather than MySQL
# # 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.Kazuho@Cybozu Labs: Pacific という名前の分散ストレージを作り始めた件
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.PERCONA PERFORMANCE CONFERENCE 2009 SCHEDULE :: PERCONA
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 onlinyHow to Create an Object-Oriented Blog Using PHP - NETTUTS
バッチHandy tips to help you out | Think Vitamin
Zajimave tipy pro webvyvoj - jquery, printstyle, geo vyhledavani...Making a Donation Center With PHP, MySQL and PayPal’s APIs – Tutorialzine
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.
PHPSecond Life Architecture - The Grid | High Scalability
Watch live mysql sql statements with dtrace
helpfulrossp.org - Full-text searching in Django with PostgreSQL and tsearch2
DESIGNjQuery, Ajax, PHP and MySQL Projects.
tons of good ajax techniques...
A Collection of jQuery and Ajax Tutorials with live demos, tutorials posted on 9lessons blog.How to Authenticate Users With Facebook Connect | Nettuts+
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!5 Rails Plugins to Help Optimize Your MySQL | Purify Blog
Bullet / SlimScrooge/ Query Reviewer / Rails Indexes / Ambitious Query IndexerPHPで大規模ブラウザゲームを開発してわかったこと
eCart - Powerful open source eCommerce platform - http://www.ecartcommerce.com/
ecard is a powerfull ecommerce platfom and a top rated magento alternativeeCart - Powerful open source eCommerce platform
Tiene buena pinta
eCart - Powerful open source eCommerce platform - http://www.ecartcommerce.com/Top 10 MySQL GUI Tools — DatabaseJournal.com
B上我们都建立了shard_001和shard_002两个逻辑数据库， Node-A上的shard_001和Node-B上的shard_001组成一个Shard，而同一时间只有一个逻辑数据库处于Active状态InfoQ: 又拍网架构中的分库设计
B上我们都建立了shard_001和shard_002两个逻辑数据库， Node-A上的shard_001和Node-B上的shard_001组成一个Shard，而同一时间只有一个逻辑数据库处于Active状态Falling foul of special characters « simon r jones
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.Falling foul of special characters « simon r jones
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.Introduction to MySQL Triggers | Nettuts+