Revision 8736
Added by Aaron Marcuse-Kubitza almost 12 years ago
index.htm | ||
---|---|---|
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> |
Also available in: Unified diff
lib/Firefox_bookmarks.reformat.csv: label page's description: don't label an author-added quotation (which starts with " ) as the page's description