Pages tagged sql:

Rules of Database App Aging - Push cx
http://push.cx/2009/rules-of-database-app-aging

"all fields become optional" etc. good stuff.
Rule 3. (too true!) Chatter Always Expands
This will be incomprehensible to non developers in the audience, but oh god, this is so painfully, painfully true.
"I mentioned I’ve learned some rules of how database apps change over time, now that I’ve done a few dozen. They are: ... "
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.
wwwsqldesigner - Google Code
http://code.google.com/p/wwwsqldesigner/
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 ~ 百式管理人のライフハックブログ ~
http://www.ideaxidea.com/archives/2009/01/www_sql_designer.html
これは次回使いたい。
Listable
http://www.listable.org/
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)
32 Tips To Speed Up Your MySQL Queries | AjaxLine
http://www.ajaxline.com/32-tips-to-speed-up-your-mysql-queries
Is the Relational Database Doomed? - ReadWriteWeb
http://www.readwriteweb.com/archives/is_the_relational_database_doomed.php
Recently, a lot of new non-relational databases have cropped up both inside and outside the cloud.
Article about where key/value databases should be used over relational databases, with some examples of dbs available.
purpose of the key/value databases. is the paradigm changing these days?
CodeProject: Visual Representation of SQL Joins. Free source code and programming help
http://www.codeproject.com/KB/database/Visual_SQL_Joins.aspx
漢(オトコ)のコンピュータ道: MySQLを高速化する10の方法
http://nippondanji.blogspot.com/2009/02/mysql10.html
tuning tips
DBのチューニング
Araelium Group : Querious - MySQL Database Tool
http://www.araelium.com/querious/
Looks hot. Hopefully less crash prone than MySQL Administrator. Will try.
MySQL Database editing app for OS X
PostgreSQLを高速化する16のポイント
http://neta.ywcafe.net/000960.html
ここ数年のPostgreSQLの進化はすさまじく、2009年現在においてその性能はOracleと同等かそれより速い。
postgresqlを使う時に読み返したい
Everything You Need to Get Started With MySQL - NETTUTS
http://net.tutsplus.com/tutorials/php/everything-you-need-to-get-started-with-mysql/
Everything You Need to Get Started With MySQL - NETTUTS
IP address geolocation SQL database | Share your knowledge!
http://blogama.org/node/58
IP address geolocation SQL database
http://www.iplocationtools.com/sql_database.php
Free downloadable IP address to long/lat SQL database
free IP address geolocation SQL database
Jedi/Sector One's random thoughts - An overview of modern SQL-free databases
http://00f.net/2009/an-overview-of-modern-sql-free-databases
Alternatives to SQL Databases [LWN.net]
http://lwn.net/Articles/328487/
Traditional SQL databases with "ACID" properties (Atomicity, Consistency, Isolation and Durability) give strong guarantees about what happens when data is stored and retrieved. These guarantees make it easier for application developers, freeing them from thinking about exactly how the data is stored and indexed, or even which database is running. However, these guarantees come with a cost.
漢(オトコ)のコンピュータ道: MySQLのEXPLAINを徹底解説!!
http://nippondanji.blogspot.com/2009/03/mysqlexplain.html
With YQL Execute, the Internet becomes your database (Yahoo! Developer Network Blog)
http://developer.yahoo.net/blog/archives/2009/04/yql_execute.html
The Yahoo! Query Language lets you query, filter, and join data across any web data source or service on the web. Using our YQL web service, apps run faster with fewer lines of code and a smaller network footprint. YQL uses a SQL-like language because it is a familiar and intuitive method for developers to access data. YQL treats the entire web as a source of table data, enabling developers to select * from Internet.
YQL + Linked Data = possibilities
Execute elements run server-side JavaScript with E4X (na
How SQLite Is Tested
http://www.sqlite.org/testing.html
Describes the testing of SQLite. Great overview of various testing techniques and how they've been applied to a significant software project.
10 Essential SQL Tips for Developers - Nettuts+
http://net.tutsplus.com/tutorials/other/10-essential-sql-tips-for-developers/
MIT Database Systems (6.830) TA Course Notes - marcua's blog
http://blog.marcua.net/post/117671929/mit-database-systems-6-830-ta-course-notes
Computer Science and Artificial Intelligence Laboratory. Navigate * Website * Twitter * Subscribe * Archives * Random Subscribe by Email MIT Database Systems (6.830) TA Course Notes In Fall 2008, I had the pleasure of TAing Database Systems with Sam Madden, Mike Stonebraker, and Evan Jones. I figured that I could take notes to help students follow the lectures while clarifying any confusing points that were raised during discussion. It would also help me avoid the embarrassment of forgetting something mentioned during a lecture and having students explain it to me during office hours:). I decided to take notes in plain text, mostly out of laziness. This turned out to be a challenge for drawing things like query plans, but forced me to distill explanations into a conversational tone that provided an alternative to traditional diagrams. Some students in the class told me that they benefited from and enjoyed the notes, and so I decided to open them up for reuse
Why CouchDB?
http://books.couchdb.org/relax/why-couchdb
man, I really really wish I understood this stuff.
shows
“Django may be built for the Web, but CouchDB is built of the Web. I’ve never seen software that so completely embraces the philosophies behind HTTP. CouchDB makes Django look old-school in the same way that Django makes ASP look outdated.”
ebook on why you would choose couchdb
A List Apart: Articles: Indexing the Web—It’s Not Just Google’s Business
http://www.alistapart.com/articles/indexing-the-web-its-not-just-googles-business/
a basic one about optimizing database query execution time
Indexing the Web
Camelot – Trac
http://www.conceptive.be/projects/camelot
A python GUI framework on top of Sqlalchemy and PyQt, inspired by the Django admin interface. Start building desktop applications at warp speed, simply by adding some additional information to you model definition.
A python GUI framework on top of Sqlalchemy and PyQt
IP address geolocation SQL database :: IPInfoDB
http://ipinfodb.com/ip_database.php
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.
jLinq - Javascript Query Language
http://www.hugoware.net/
jLinq is a Javascript library that lets you write queries against arrays of javascript objects. jLinq is completely extensible so you can write your add-ins and they will work with the rest of the framework without any additional programming!
jLinq is a javascript library that lets you write queries against arrays of javascript objects. It's completely extensible so you can write your add-ins and they will work with the rest of the framework without any additional programming.
No to SQL? Anti-database movement gains steam
http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9135086
No to SQL? Anti-database movement gains steam
The meet-up in San Francisco last month had a whiff of revolution about it, like a latter-day techie version of the American Patriots planning the Boston Tea Party. The inaugural get-together of the burgeoning NoSQL community crammed 150 attendees into a meeting room at CBS Interactive. Like the Patriots, who rebelled against Britain's heavy taxes, NoSQLers came to share how they had overthrown the tyranny of slow, expensive relational databases in favor of more efficient and cheaper ways of managing data. "Relational databases give you too much. They force you to twist your object data to fit a RDBMS [relational database management system]," said Jon Travis, principal engineer at Java toolmaker SpringSource, one of the 10 presenters at the NoSQL confab (PDF). NoSQL-based alternatives "just give you what you need," Travis said. Open source rises up The movement's chief champions are Web and Java developers, many of whom learned to get by at their cash-strapped startups without Ora
The meet-up in San Francisco last month had a whiff of revolution about it, like a latter-day techie version of the American Patriots planning the Boston Tea Party.
piece on an alternative approach to data management
SQL Databases Are An Overapplied Solution (And What To Use Instead)
http://adam.blog.heroku.com/past/2009/7/8/sql_databases_are_an_overapplied_solution_and_what_to_use_instead/
SQL Databases Are An Overapplied Solution (And What To Use Instead)
How b-tree database indexes work and how to tell if they are efficient (100' level) | mattfleming.com
http://mattfleming.com/node/192
A team member thought we should add an index on a 90 million row table to improve performance. The field on which he wanted to create this index had only four possible values. To which I replied that an index on a low cardinality field wasn't really going to help anything. My boss then asked me why wouldn't it help? I sputtered around for a response but ended up telling him that I'd get back to him with a reasonable explanation.
Imported from http://twitter.com/newsycombinator/status/2645303258 How b-tree database indexes work and how to tell if they are efficient http://bit.ly/dd6mf
My Thoughts on NoSQL - Die in a Fire - Eric Florenzano’s Blog
http://www.eflorenzano.com/blog/post/my-thoughts-nosql/
Over the past few years, relational databases have fallen out of favor for a number of influential people in our industry. I'd like to weigh in on that, but before doing so, I'd like to give my executive summary of the events leading up to this movement
Tokyo Cabinet
Обзор нескольких опенсурсных нереляционных БД.
Thoughts on NoSQL, Tokyo Cabinet, CouchDB, Redis, and Cassandra.
%postname%
http://lazytechie.com/top-84-mysql-performance-tips/
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
NoSQL: If Only It Was That Easy « Marked As Pertinent
http://bjclark.me/2009/08/04/nosql-if-only-it-was-that-easy/
Intéressant, une étude des différentes db alternatives sous l'angle de la scalabilité
http://aws.amazon.com/s3/
data store scaling technologies
SQL pie chart | code.openark.org
http://code.openark.org/blog/mysql/sql-pie-chart
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 でアスキーアート的なもの。
csharp-sqlite - Project Hosting on Google Code
http://code.google.com/p/csharp-sqlite/
How to find un-indexed queries in MySQL, without using the log at Xaprb
http://www.xaprb.com/blog/2009/08/18/how-to-find-un-indexed-queries-in-mysql-without-using-the-log/
MySQLで索引を使っていないクエリーをログを調べずに見つける方法
Using PHP/MySQL with Google Maps - Google Maps API - Google Code
http://code.google.com/apis/maps/articles/phpsqlajax_v3.html
Dare Obasanjo aka Carnage4Life - Building Scalable Databases: Denormalization, the NoSQL Movement and Digg
http://www.25hoursaday.com/weblog/2009/09/10/BuildingScalableDatabasesDenormalizationTheNoSQLMovementAndDigg.aspx
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
bobby-tables.com: A guide to preventing SQL injection
http://bobby-tables.com/
漢(オトコ)のコンピュータ道: なぜMySQLのサブクエリは遅いのか。
http://nippondanji.blogspot.com/2009/03/mysql_25.html
サブクエリ、あんまりよくない理由
というわけでMySQLによるサブクエリの処理について見てきたが、きちんと気をつけて使えばサブクエリも高速に実行される。もちろんJOINに書き換えた方が速いのは言うまでもないが、SQL文のメンテナンスし易さなどを考えるとサブクエリで処理を書きたい!という人も居るのではないだろうか。そんな方は次の事に気をつけてサブクエリを使って頂きたい。 * サブクエリの種類 * 外部クエリとサブクエリの評価の順序 * 外部クエリにおいてフェッチされる行数 * サブクエリで利用されるインデックス * テンポラリテーブルのサイズ
SQL Databases Don't Scale
http://adamblog.heroku.com/past/2009/7/6/sql_databases_dont_scale/
Graphs in the database: SQL meets social networks – techPortal
http://techportal.ibuildings.com/2009/09/07/graphs-in-the-database-sql-meets-social-networks/
"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."
PostgreSQL Tips and Tricks | gtuhl: startup technology
http://blog.gtuhl.com/2009/08/07/postgresql-tips-and-tricks/
Here’s a dozen tips for working with a PostgreSQL database. It is a sophisticated and powerful piece of software and just knowing a few rules of thumb before diving in can be a huge help.
Here’s a dozen tips for working with a PostgreSQL database. It is a sophisticated and powerful piece of software and just knowing a few rules of thumb before diving in can be a huge help. If you want more detail read the amazing documention. My list of tips was very long so I just chopped off a dozen for this post.
Sql Antipatterns Strike Back
http://www.slideshare.net/billkarwin/sql-antipatterns-strike-back?src=embed
Great presentation about good SQL practice.
interesting but it's a slideshow rather than an article
The End of a DBMS Era (Might be Upon Us) | blog@CACM | Communications of the ACM
http://cacm.acm.org/blogs/blog-cacm/32212-the-end-of-a-dbms-era-might-be-upon-us/fulltext
"Relational database management systems (DBMSs) have been remarkably successful in capturing the DBMS marketplace. To a first approximation they are “the only game in town,” and the major vendors (IBM, Oracle, and Microsoft) enjoy an overwhelming market share. They are selling “one size fits all”; i.e., a single relational engine appropriate for all DBMS needs. Moreover, the code line from all of the major vendors is quite elderly, in all cases dating from the 1980s. Hence, the major vendors sell software that is a quarter century old, and has been extended and morphed to meet today’s needs. In my opinion, these legacy systems are at the end of their useful life. They deserve to be sent to the “home for tired software.” Here’s why."
NoSQL: Distributed and Scalable Non-Relational Database Systems | Linux Magazine
http://www.linux-mag.com/cache/7579/1.html
From @jesserobbins
Non-SQL oriented distributed databases are all the rage in some circles. They’re designed to scale from day 1 and offer reliability in the face of failures.
NoSQL: Distributed and Scalable Non-Relational Database Systems
l
AMIS Technology blog » Blog Archive » Oracle RDBMS 11gR2 - Solving a Sudoku using Recursive Subquery Factoring
http://technology.amis.nl/blog/6404/oracle-rdbms-11gr2-solving-a-sudoku-using-recursive-subquery-factoring
Solving a Sudoku using Recursive Subquery Factoring
OracleのSQL再起処理で数独を解く
AMIS Technology blog » Blog Archive » Oracle RDBMS 11gR2 - Solving a Sudoku using Recursive Subquery Factoring
SQL Databases Don't Scale
http://adam.blog.heroku.com/past/2009/7/6/sql_databases_dont_scale/
"Sharding kills most of the value of a relational database."
sql database db
データベースの基礎を理解しよう! プログラミング未経験から始めるPHP入門:CodeZine
http://codezine.jp/article/detail/3685
EXPLAIN EXTENDED: efficient database queries in SQL.
http://explainextended.com/
In the Woods - A Closer Look at SQL Joins
http://blog.themeforest.net/tutorials/a-closer-look-at-sql-joins/
JOINs em Mysql
Top 20+ MySQL Best Practices - Nettuts+
http://net.tutsplus.com/tutorials/other/top-20-mysql-best-practices/
5. Index and Use Same Column Types for Joins
** Posted using Viigo: Mobile RSS, Sports, Current Events and more **
20 Best practices
Top 20+ MySQL Best Practices - Nettuts+
http://net.tutsplus.com/tutorials/other/top-20-mysql-best-practices/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+nettuts+%28NETTUTS%29
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 と drizzle の負荷テストツール「skyload」が凄い! - id:kazuhookuのメモ置き場
http://d.hatena.ne.jp/kazuhooku/20090707/1246950315
MySQLの負荷テストに便利らしい。
assertTrue( ): NoSQL Required Reading
http://asserttrue.blogspot.com/2009/12/nosql-required-reading.html
Starting from Dynamo, ending with (roughly) follow @nosqlupdate on Twitter.
Materials that you need to read in order to get started with NoSQL
List of resources to read to get up-to-speed on the NoSQL movement.
Top 20+ MySQL Best Practices | TuVinhSoft .,JSC
http://blog.tuvinh.com/top-20-mysql-best-practices/
Free Tools for the SQL Server DBA Part 2 - SQL Server Central
http://www.sqlservercentral.com/articles/Tools/64908
MySQL Showdown: Querious vs. Sequel Pro - TheAppleBlog
http://theappleblog.com/2009/02/27/mysql-showdown-querious-vs-sequel-pro/
Sql Antipatterns Strike Back
http://www.slideshare.net/billkarwin/sql-antipatterns-strike-back
"Common blunders of SQL database design, queries, and software development. Presented as a tutorial at the MySQL Conference & Expo 2009."
none
Trees In The Database - Advanced data structures
http://www.slideshare.net/quipo/trees-in-the-database-advanced-data-structures?type=presentation
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
jLinq - LINQ for JSON
http://www.hugoware.net/Projects/jLinq
jLinq is a fully extensible Javascript library that allows you to perform LINQ style queries on arrays of object.
Vineet Gupta: NoSql Databases – Part 1 - Landscape
http://www.vineetgupta.com/2010/01/nosql-databases-part-1-landscape.html
At Directi, we are taking a hard look at the way our applications need to store and retrieve data, and whether we really need to use a traditional RDBMS for all scenarios. This does not mean that we will eschew relational systems altogether. What it means is that we will use the best tool for the job – we will use non-relational options wherever needed and not throw everything at a relational database with a mindless one-size-fits-all approach. ... ... This post covers the current landscape of the NoSQL space. In a subsequent post, I intend to cover in more detail the various problem areas addressed by NoSQL systems and the specific algorithms used.
Really detailed description of a number of NoSQL solutions. Interesting reading on Cassandra and Voldemort.
This post covers the current landscape of the NoSQL space. In a subsequent post, I intend to cover in more detail the various problem areas addressed by NoSQL systems and the specific algorithms used.
ウノウラボ Unoh Labs: RDBで階層構造を扱うには?
http://labs.unoh.net/2009/06/rdb.html
how to store tree structure on RDB
階層構造
SQL for Beginners - Nettuts+
http://net.tutsplus.com/tutorials/other/sql-for-beginners/
*****
9 Tips For Working with MySQL Databases » DevSnippets
http://devsnippets.com/article/9-tips-for-working-with-mysql-databases.html
Less Than Dot - Blog - The Ten Most Asked SQL Server Questions And Their Answers
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1
Getting all rows from one table and only the latest from the child table
1) Selecting all the values from a table for a particular date 2) Search all columns in all the tables in a database for a specific value 3) Splitting string values 4) Select all rows from one table that don't exist in another table 5) Getting all rows from one table and only the latest from the child table 6) Getting all characters until a specific character 7) Return all rows with NULL values in a column 8) Row values to column (PIVOT) 9) Pad or remove leading zeroes from numbers 10) Concatenate Values From Multiple Rows Into One Column
5 useful PHP functions for MySQL data fetching - AnyExample.com
http://www.anyexample.com/programming/php/5_useful_php_functions_for_mysql_data_fetching.xml
Muy, interesante, recomendaciones para recuperar información de mysql
13 Useful WordPress SQL Queries You Wish You Knew Earlier | Onextrapixel - Showcasing Web Treats Without Hitch
http://www.onextrapixel.com/2010/01/30/13-useful-wordpress-sql-queries-you-wish-you-knew-earlier/
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
Four ways to optimize paginated displays | MySQL Performance Blog
http://www.mysqlperformanceblog.com/2008/09/24/four-ways-to-optimize-paginated-displays/
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.
python-sqlparse - Google Code
http://code.google.com/p/python-sqlparse/
sqlparse is a non-validating SQL parser for Python. It provides support for parsing, splitting and formatting SQL statements.
sqlparse is a non-validating SQL parser for Python. It provides support for parsing, splitting and formatting SQL statements.
Support for parsing, splitting and formatting SQL statements.
Ask SM: PHP/MySQL Security | How-To | Smashing Magazine
http://www.smashingmagazine.com/2009/04/01/ask-sm-phpmysql-security/
25+ Alternative & Open Source Database Engines
http://www.webresourcesdepot.com/25-alternative-open-source-databases-engines/
25+ Alternative & Open Source Database Engines
RT @tweetlicius: 25+ Alternative & Open Source Database Engines - http://bit.ly/cRDaOW
Free Web Resources Everyday - WebResourcesDepot
Common Queries Tree
http://www.artfulsoftware.com/infotree/queries.php?&bw=1280
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
JSINQ - LINQ to Objects for JavaScript - Home
http://www.codeplex.com/jsinq
There are side-benefits to immersing yourself in MS-land. Like finding really solid data manipulation libraries written in javascript.
JSINQ is a complete implementation of LINQ to Objects for JavaScript. It allows you to write SQL-like queries against arrays, DOM node lists or your own custom enumerable types.
JSINQ is the JavaScript library that allows you to write SQL-like queries against arrays and DOM node lists. JSINQ is a complete implementation of LINQ to Objects in JavaScript. What that means is that if you know LINQ and you know JavaScript, you know JSINQ. JSINQ is both an API-compatible implementation of System.Linq.Enumerable and a complete query-expression compiler. That's right: you can write LINQ-style queries in JavaScript. And if that isn't enough: JSINQ is also very liberally licensed, well-document, reasonably well-tested (the Enumerable-part) and currently in beta. So give it a go!
WordPress : 10+ life saving SQL queries
http://www.catswhocode.com/blog/wordpress-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
http://www.chive-project.com/
Dennis Forbes on Software and Technology - Getting Real about NoSQL and the SQL-Isn't-Scalable Lie
http://www.yafla.com/dforbes/Getting_Real_about_NoSQL_and_the_SQL_Isnt_Scalable_Lie/
SQL is Scalable and NoSQL Isn’t For Everyone The point is one that I think all rational people already realize: The ACID RDBMS isn’t appropriate for every need, nor is the NoSQL solution.
"[Though as Michael Stonebraker points out, SQL the query language actually has remarkably little to actually to do with the debate. It would be more clearly called NoACID]"
10 sql tips to speed up your database
http://www.catswhocode.com/blog/10-sql-tips-to-speed-up-your-database
SQL optimization
10 sql tips to speed up your database http://bit.ly/9uIi6k #sql
Stupid Coding Tricks: The T-SQL Mandelbrot - The Daily WTF
http://thedailywtf.com/Articles/Stupid-Coding-Tricks-The-TSQL-Madlebrot.aspx
JOB
Try jLinq Online
http://www.hugoware.net/TryOnline
jLinq is a Javascript library that makes working with complex arrays easy. jLinq was built based on adding functions to the core library so it is easily extended with your own custom code. jLinq is free and open source so you can contribute your creations and help improve the library!
jLINQ
配列をデータベースっぽく扱うことができるJavaScriptのライブラリ『jLinq』
Are Commercial Databases Worth It? - Coding the Wheel
http://www.codingthewheel.com/archives/are-commercial-databases-worth-it
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.
Visual Guide to NoSQL Systems - Nathan Hurst's Blog
http://blog.nahurst.com/visual-guide-to-nosql-systems
Good discussion in the comments as well.
JDbMonitor - Monitor JDBC Performance For Slow SQL Queries
http://www.jdbmonitor.com/
JDbMonitor is a tool to monitor & analyse database performance for any Java application. Easily determine your application's database performance and analyse problems down to specific SQL statement.
Tool for monitoring JDBC database activity
Monitor JDBC Performance For Slow SQL Queries
4 Steps To a Professional Database Design | ProgrammerFish - Everything that's programmed!
http://www.programmerfish.com/4-steps-to-a-professional-database-design/
Just as you require a blueprint to build a house, you will need a database blueprint in order to implement a database successfully .
SQL Server 2005 Paging – The Holy Grail - SQL Server Central
http://www.sqlservercentral.com/articles/T-SQL/66030/
The paging and ranking functions introduced in 2005 are old news by now, but the typical ROW_NUMBER OVER() implementation only solves part of the problem. Nearly every application that uses paging gives some indication of how many pages (or total records) are in the total result set. The challenge is to query the total number of rows, and return only the desired records with a minimum of overhead? The holy grail solution would allow you to return one page of the results and the total number of rows with no additional I/O overhead. In this article, we're going to explore four approaches to this problem and discuss their relative strengths and weaknesses. For the purposes of comparison, we'll be using I/O as a relative benchmark.
IP address city geolocation HTTP API | Share your knowledge!
http://blogama.org/node/60
Api para geolocalizacion del IP
blog.TBODA.com | 5 Useful SQL Server Scripts
http://blog.tboda.com/post/5-Useful-SQL-Server-Scripts.aspx
MySQLによるデータウェアハウス構築 (Yahoo! JAPAN Tech Blog)
http://techblog.yahoo.co.jp/web/yahoo/mysql/
バッチ
Using DTrace to observe the SQL statements on a live running MySQL database : Angelo's Soapbox
http://blogs.sun.com/angelo/entry/observing_mysql_sql_statements_in
Watch live mysql sql statements with dtrace
helpful
rossp.org - Full-text searching in Django with PostgreSQL and tsearch2
http://www.rossp.org/blog/2009/jan/28/django-postgresql-fulltext/
SQLike - a small query engine
http://www.thomasfrank.se/sqlike.html
SQLike is a small (10 kB) query engine for JavaScript and ActionScript. Its functionality and syntax is similar to that of SQL and it can be used to query arrays of objects or arrays of arrays.
VoltDB: Fast, Scalable SQL RDBMS with ACID
http://www.voltdb.com/
SCALABLE, OPEN-SOURCE SQL DBMS WITH ACID
MySQL Format Date | date_format Tool
http://www.mysqlformatdate.com/
DESIGN
WEBプログラマー必見!WEB脆弱性基礎知識最速マスター - 燈明日記
http://d.hatena.ne.jp/chaichanPaPa/20100509/1273376018
以下の一覧にまとめ。。。 * インジェクション * クロスサイト・スクリプティング * セッション・ハイジャック * アクセス制御や認可制御の欠落 * ディレクトリ・トラバーサル (Directory Traversal) * CSRF(クロスサイト・リクエスト・フォージェリ)
5 Rails Plugins to Help Optimize Your MySQL | Purify Blog
http://blog.purifyapp.com/2010/06/15/optimise-your-mysql/
Bullet / SlimScrooge/ Query Reviewer / Rails Indexes / Ambitious Query Indexer
Top 10 MySQL GUI Tools — DatabaseJournal.com
http://www.databasejournal.com/features/mysql/article.php/3880961/article.htm
Introduction to MySQL Triggers | Nettuts+
http://net.tutsplus.com/tutorials/databases/introduction-to-mysql-triggers/
mysql触发器介绍