Project

General

Profile

« Previous | Next » 

Revision 8736

lib/Firefox_bookmarks.reformat.csv: label page's description: don't label an author-added quotation (which starts with " ) as the page's description

View differences:

lib/Firefox_bookmarks.reformat.csv
18 18
</DD>",close <DD> when followed by tags which don't autoclose it properly
19 19
" ICON=""data:.*?""",,"remove ICON attributes with favicon contents, which clutter up the svn diffs"
20 20
" LAST_MODIFIED="".*?""",,"remove LAST_MODIFIED attributes, which seem to change whenever the favicon is updated and clutter up the svn diff"
21
(?<=^<DD>)(?:[^:\n]*? description: )?,page's description: ,"label page's description as such to avoid confusing it with comments added by the bookmark author, who may not agree with it. the page's description is in the 1st paragraph(s), when provided."
21
(?<=^<DD>)(?!&quot;)(?:[^:\n]*? description: )?,page's description: ,"label page's description as such to avoid confusing it with comments added by the bookmark author, who may not agree with it. the page's description is in the 1st paragraph(s), when provided. if the bookmark desc starts with "" , this is an author-added quotation and not the page's description."
web/links/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: &quot;
116
<DD>&quot;
117 117
&gt; /* if someone used the PASSTHROUGH flag in per-dir
118 118
&gt; * context we just ignore it. It is only useful
119 119
&gt; * in per-server context
120 120
&gt; */
121 121
&quot;
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: &quot;In Lighttpd you&#39;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.&quot;
123
<DD>&quot;In Lighttpd you&#39;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.&quot;
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: &quot;Stored procedures called from triggers operate under the same restrictions as triggers, i.e., no dynamic SQL is allowed.&quot;
184
<DD>&quot;Stored procedures called from triggers operate under the same restrictions as triggers, i.e., no dynamic SQL is allowed.&quot;
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: &quot;we use varchar(32) for primary keys (GUIDs) and we haven&#39;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.&quot;
198
<DD>&quot;we use varchar(32) for primary keys (GUIDs) and we haven&#39;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.&quot;
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: &quot;VARCHAR isn&#39;t a valid type for the CAST function, but CHAR is.&quot;
210
<DD>&quot;VARCHAR isn&#39;t a valid type for the CAST function, but CHAR is.&quot;
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 &lt; 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: &quot;Because modifying the columns of the clustered index is an expensive operation, choose primary columns that are rarely or never updated.&quot;
238
<DD>&quot;Because modifying the columns of the clustered index is an expensive operation, choose primary columns that are rarely or never updated.&quot;
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: &quot;PostgreSQL will feature the MERGE clause in a future version [5], which follows the SQL:2008 standard. This can do the same as MySQL&#39;s non-standard &#39;INSERT IGNORE&#39;,&#39;REPLACE&#39; and &#39;INSERT ... ON DUPLICATE UPDATE&#39; statements but with more granularity.&quot;
315
<DD>&quot;PostgreSQL will feature the MERGE clause in a future version [5], which follows the SQL:2008 standard. This can do the same as MySQL&#39;s non-standard &#39;INSERT IGNORE&#39;,&#39;REPLACE&#39; and &#39;INSERT ... ON DUPLICATE UPDATE&#39; statements but with more granularity.&quot;
316 316

  
317 317
&quot;MySQL triggers are also not activated by cascading updates and deletes even when caused by a SQL statement&quot;
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: &quot;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&quot;
394
<DD>&quot;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&quot;
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: &quot;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&quot;
488
<DD>&quot;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&quot;
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