113 |
113 |
<DT><A HREF="http://httpd.apache.org/docs/2.2/mod/mod_autoindex.html#indexoptions.descriptionwidth" ADD_DATE="1363420108" ICON_URI="http://httpd.apache.org/docs/2.2/images/favicon.ico" LAST_CHARSET="ISO-8859-1">mod_autoindex - Apache HTTP Server</A>
|
114 |
114 |
<DT><A HREF="http://httpd.apache.org/docs/2.2/rewrite/flags.html#flag_dpi" ADD_DATE="1363354438" ICON_URI="http://httpd.apache.org/docs/2.2/images/favicon.ico" LAST_CHARSET="ISO-8859-1">RewriteRule Flags - Apache HTTP Server</A>
|
115 |
115 |
<DT><A HREF="https://issues.apache.org/bugzilla/show_bug.cgi?id=31210" ADD_DATE="1365850001" ICON_URI="https://issues.apache.org/bugzilla/images/favicon.ico" LAST_CHARSET="UTF-8">Bug 31210 – Problematic competition between mod_rewrite and mod_dir</A>
|
116 |
|
<DD>page's description: "
|
|
116 |
<DD>"
|
117 |
117 |
> /* if someone used the PASSTHROUGH flag in per-dir
|
118 |
118 |
> * context we just ignore it. It is only useful
|
119 |
119 |
> * in per-server context
|
120 |
120 |
> */
|
121 |
121 |
"
|
122 |
122 |
<DT><A HREF="http://www.wikivs.com/wiki/Apache_vs_Lighttpd" ADD_DATE="1365931468" ICON_URI="http://www.wikivs.com/favicon.ico" LAST_CHARSET="UTF-8">Apache vs Lighttpd - WikiVS</A>
|
123 |
|
<DD>page's description: "In Lighttpd you're restricted to rewriting via the config level only, which means for things like Wordpress you will need to hard code the rewrite rule in."
|
|
123 |
<DD>"In Lighttpd you're restricted to rewriting via the config level only, which means for things like Wordpress you will need to hard code the rewrite rule in."
|
124 |
124 |
</DL><p>
|
125 |
125 |
<DT><H3 ADD_DATE="1367306535">BitTorrent Sync</H3>
|
126 |
126 |
<DD>page's description: -
|
... | ... | |
181 |
181 |
<DT><A HREF="http://stackoverflow.com/questions/190776/how-to-have-dynamic-sql-in-mysql-stored-procedure" ADD_DATE="1366898705" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8">How To have Dynamic SQL in MySQL Stored Procedure - Stack Overflow</A>
|
182 |
182 |
<DT><A HREF="http://www.it-iss.com/mysql/mysql-writing-dynamic-sql-in-stored-procedures/" ADD_DATE="1366898755" ICON_URI="http://www.it-iss.com/favicon.ico" LAST_CHARSET="UTF-8">MySQL – Writing dynamic SQL in stored procedures « IT Integrated Business Solutions</A>
|
183 |
183 |
<DT><A HREF="http://forums.mysql.com/read.php?125,127701,127719#msg-127719" ADD_DATE="1366898787" ICON_URI="http://forums.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8">MySQL :: Re: Dynamic SQl in Triggers/Procdures</A>
|
184 |
|
<DD>page's description: "Stored procedures called from triggers operate under the same restrictions as triggers, i.e., no dynamic SQL is allowed."
|
|
184 |
<DD>"Stored procedures called from triggers operate under the same restrictions as triggers, i.e., no dynamic SQL is allowed."
|
185 |
185 |
</DL><p>
|
186 |
186 |
<DT><H3 ADD_DATE="1366740023">MySQL Workbench</H3>
|
187 |
187 |
<DL><p>
|
... | ... | |
195 |
195 |
<DT><H3 ADD_DATE="1366864765">string primary keys</H3>
|
196 |
196 |
<DL><p>
|
197 |
197 |
<DT><A HREF="http://stackoverflow.com/questions/2250545/performance-penalty-of-strings-as-primary-keys" ADD_DATE="1366864782" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8">mysql - performance penalty of strings as primary keys? - Stack Overflow</A>
|
198 |
|
<DD>page's description: "we use varchar(32) for primary keys (GUIDs) and we haven't met performance issues of this. Our product is a web site with extreme overload and is critical to be stable. We use SQL Server 2005."
|
|
198 |
<DD>"we use varchar(32) for primary keys (GUIDs) and we haven't met performance issues of this. Our product is a web site with extreme overload and is critical to be stable. We use SQL Server 2005."
|
199 |
199 |
</DL><p>
|
200 |
200 |
<DT><H3 ADD_DATE="1366900069">vs. other SQL DBs</H3>
|
201 |
201 |
<DL><p>
|
... | ... | |
207 |
207 |
<DT><A HREF="http://ariejan.net/2008/11/27/export-csv-directly-from-mysql/" ADD_DATE="1364875901" ICON_URI="http://ariejan.net/images/favicon.ico" LAST_CHARSET="UTF-8">ariejan.net</A>
|
208 |
208 |
<DD>page's description: a blog by ariejan de vroom about software engineering and craftsmanship.
|
209 |
209 |
<DT><A HREF="http://stackoverflow.com/questions/989643/how-to-use-the-cast-function-correctly-in-a-mysql-select-statement" ADD_DATE="1366752124" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8">casting - How to use the CAST function correctly in a MySql SELECT statement? - Stack Overflow</A>
|
210 |
|
<DD>page's description: "VARCHAR isn't a valid type for the CAST function, but CHAR is."
|
|
210 |
<DD>"VARCHAR isn't a valid type for the CAST function, but CHAR is."
|
211 |
211 |
<DT><A HREF="http://skyontech.com/blog/create-MySQL-view-in-phpMyAdmin" ADD_DATE="1364874584" ICON_URI="http://skyontech.com/blog/misc/favicon.ico" LAST_CHARSET="UTF-8">Creating a MySQL View directly in phpMyAdmin | Sky on Tech</A>
|
212 |
212 |
<DT><A HREF="http://www.bluebox.net/about/blog/2009/07/mysql_encoding/" ADD_DATE="1366749540" ICON_URI="http://www.bluebox.net/favicon.ico" LAST_CHARSET="UTF-8">Getting out of MySQL Character Set Hell < Blue Box Blog</A>
|
213 |
213 |
<DT><A HREF="http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html" ADD_DATE="1366764865" ICON_URI="http://s0.cyberciti.org/static/legacy/i/favicon.ico" LAST_CHARSET="UTF-8">How Do I Enable Remote Access To MySQL Database Server?</A>
|
... | ... | |
235 |
235 |
<DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/index-btree-hash.html" ADD_DATE="1366865295" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8">MySQL :: MySQL 5.5 Reference Manual :: 8.3.8 Comparison of B-Tree and Hash Indexes</A>
|
236 |
236 |
<DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/identifiers.html" ADD_DATE="1366748434" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8">MySQL :: MySQL 5.5 Reference Manual :: 9.2 Schema Object Names</A>
|
237 |
237 |
<DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_clustered_index" ADD_DATE="1366896044" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8">MySQL :: MySQL 5.5 Reference Manual :: MySQL Glossary :: clustered index</A>
|
238 |
|
<DD>page's description: "Because modifying the columns of the clustered index is an expensive operation, choose primary columns that are rarely or never updated."
|
|
238 |
<DD>"Because modifying the columns of the clustered index is an expensive operation, choose primary columns that are rarely or never updated."
|
239 |
239 |
<DT><A HREF="http://dev.mysql.com/doc/refman/5.6/en/alter-database.html" ADD_DATE="1346340363" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8">MySQL :: MySQL 5.6 Reference Manual :: 13.1.1 ALTER DATABASE Syntax</A>
|
240 |
240 |
<DT><A HREF="http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html" ADD_DATE="1346821922" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8">MySQL :: MySQL 5.6 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program</A>
|
241 |
241 |
<DT><A HREF="http://forums.mysql.com/read.php?28,243757,245694" ADD_DATE="1361398973" ICON_URI="http://forums.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8">MySQL :: Re: How to Restore a particular table from the mysqldump of a whole database?</A>
|
... | ... | |
312 |
312 |
<DT><A HREF="http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL" ADD_DATE="1360831167" ICON_URI="http://en.wikibooks.org/favicon.ico" LAST_CHARSET="UTF-8">Converting MySQL to PostgreSQL - Wikibooks, open books for an open world</A>
|
313 |
313 |
<DT><A HREF="http://www.sourcefiles.org/Databases/Utilities/Conversion/my2pg.pl" ADD_DATE="1360832036" ICON_URI="http://www.sourcefiles.org/favicon.ico" LAST_CHARSET="UTF-8">my2pg.pl</A>
|
314 |
314 |
<DT><A HREF="http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL" ADD_DATE="1365879925" ICON_URI="http://www.wikivs.com/favicon.ico" LAST_CHARSET="UTF-8">MySQL vs PostgreSQL - WikiVS</A>
|
315 |
|
<DD>page's description: "PostgreSQL will feature the MERGE clause in a future version [5], which follows the SQL:2008 standard. This can do the same as MySQL's non-standard 'INSERT IGNORE','REPLACE' and 'INSERT ... ON DUPLICATE UPDATE' statements but with more granularity."
|
|
315 |
<DD>"PostgreSQL will feature the MERGE clause in a future version [5], which follows the SQL:2008 standard. This can do the same as MySQL's non-standard 'INSERT IGNORE','REPLACE' and 'INSERT ... ON DUPLICATE UPDATE' statements but with more granularity."
|
316 |
316 |
|
317 |
317 |
"MySQL triggers are also not activated by cascading updates and deletes even when caused by a SQL statement"
|
318 |
318 |
<DT><A HREF="http://stackoverflow.com/questions/3579079/how-can-you-represent-inheritance-in-a-database" ADD_DATE="1365882733" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8">sql - How can you represent inheritance in a database? - Stack Overflow</A>
|
... | ... | |
391 |
391 |
<DD>page's description: phpPgAdmin is a fully functional web-based administration utility for a PostgreSQL database server. It handles all the basic functionality as well as some advanced features such as triggers, views and functions (stored procs)
|
392 |
392 |
<DT><A HREF="http://stackoverflow.com/questions/12570724/foreign-key-to-a-pg-catalog-table-in-postgresql" ADD_DATE="1362551133" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8">sql - Foreign key to a pg_catalog table in PostgreSQL - Stack Overflow</A>
|
393 |
393 |
<DT><A HREF="http://stackoverflow.com/questions/398884/postgresql-hash-index" ADD_DATE="1366152256" ICON_URI="http://stackoverflow.com/favicon.ico" LAST_CHARSET="UTF-8">sql - PostgreSQL HASH index - Stack Overflow</A>
|
394 |
|
<DD>page's description: "It should be noted that as of version 8.4 the issue with Hash indexes being less efficient and slower than b-tree indexes is resolved"
|
|
394 |
<DD>"It should be noted that as of version 8.4 the issue with Hash indexes being less efficient and slower than b-tree indexes is resolved"
|
395 |
395 |
<DT><A HREF="http://stackoverflow.com/questions/12606842/what-is-the-maximum-number-of-columns-in-a-postgresql-select-query" ADD_DATE="1360679821" ICON_URI="http://stackoverflow.com/favicon.ico" LAST_CHARSET="UTF-8">sql - What is the maximum number of columns in a PostgreSQL select query - Stack Overflow</A>
|
396 |
396 |
<DT><A HREF="http://wiki.postgresql.org/wiki/String_Functions_and_Operators_Compatibility#concat_ws" ADD_DATE="1362550434" ICON_URI="http://wiki.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8">String Functions and Operators Compatibility - PostgreSQL wiki</A>
|
397 |
397 |
</DL><p>
|
... | ... | |
485 |
485 |
<DT><H3 ADD_DATE="1365937546">git</H3>
|
486 |
486 |
<DL><p>
|
487 |
487 |
<DT><A HREF="http://viget.com/extend/a-gaggle-of-git-tips" ADD_DATE="1365937554" ICON_URI="http://viget.com/favicon.ico" LAST_CHARSET="UTF-8">A Gaggle Of Git Tips | Viget</A>
|
488 |
|
<DD>page's description: "I use git rebase -i to make sure every commit is clean. For example, when I have two commits with broken code followed by a third clean commit"
|
|
488 |
<DD>"I use git rebase -i to make sure every commit is clean. For example, when I have two commits with broken code followed by a third clean commit"
|
489 |
489 |
<DT><A HREF="http://viget.com/extend/effectively-using-git-with-subversion" ADD_DATE="1365937443" ICON_URI="http://viget.com/favicon.ico" LAST_CHARSET="UTF-8">Effectively Using Git With Subversion | Viget</A>
|
490 |
490 |
<DT><A HREF="http://emmanuelbernard.com/blog/2009/01/16/how-to-install-git-and-git-svn-on-mac-os-x/" ADD_DATE="1365938585" ICON_URI="http://emmanuelbernard.com/favicon.ico" LAST_CHARSET="UTF-8">Emmanuel Bernard: How to install Git and git-svn on Mac OS X</A>
|
491 |
491 |
</DL><p>
|
lib/Firefox_bookmarks.reformat.csv: label page's description: don't label an author-added quotation (which starts with " ) as the page's description