Deleting duplicate BibTeX entries from Mendeley

I've recently moved to using Mendeley as my main reference management tool. It has some pretty neat features except for a few that keep bugging me. One of those is that Mendeley seems to maintain record of deleted entries in its database and those end up in its BibTeX export. Worst of all is that I am always getting duplicate entries in the BibTeX file.

Today I found a neat solution based on the post by Simon Greenhill. Here's how it works for the citation key:

1. Locate your Mendeley SQLite Library (~/Library/Application Support/Mendeley Desktop/youremail@www.mendeley.com.sqlite)
2. from your terminal type:
   sqlite3 your-email-address\@www.mendeley.com.sqlite
3. Type:
   SELECT COUNT(*) as entries, citationkey FROM Documents GROUP BY citationkey HAVING entries > 1;
   This basically queries the table "Documents" for all duplicate citation keys.
4. Then,
   DELETE FROM Documents WHERE id NOT IN (SELECT MAX(id) FROM Documents GROUP BY citationkey);
   

Voila!

Cite as:
Saad, T. "Deleting duplicate BibTeX entries from Mendeley". Weblog entry from Please Make A Note. http://pleasemakeanote.blogspot.com/2010/06/deleting-duplicate-bibtex-entries-from.html

Maximize Chrome in Mac OSX

Try:

Shift + maximize button (green button)

Voila!

Cite as:
Saad, T. "Maximize Chrome in Mac OSX". Weblog entry from Please Make A Note. http://pleasemakeanote.blogspot.com/2010/05/maximize-chrome-in-mac-osx.html

Lagrangian Optimization of Wall Injected Flows

I am pleased to share some of the results of my research over the past few years. These just appeared as a review article in the Proceedings of the Royal Society A and you can download it from here (and the cool thing about the Royal Society – besides its very professional reviewers – review articles are free access to everyone!)

http://dx.doi.org/10.1098/rspa.2009.0326

I hope that you will enjoy reading this manuscript as it includes many classical ideas with a novel twist as well as some original derivations and solutions for flows at large Reynolds numbers.

The heart of this research resides in the fact that we were able to capture solutions that range from purely irrotational to highly rotational fields using a single formulation. These have different energy signatures and morph according to the energy level they are at. The second law of thermodynamics is then used to identify which of those solutions is the most likely to occur in practice based on the entropy maximization principle. Finally, Kelvin’s minimum energy theorem is extended to open regions thus granting it applicability to a wider class of problems. It is used here to prove that the solution with minimum kinetic energy corresponds indeed to the irrotational motion.

Working on this article is one of the main reasons that I have not been posting recently,

Cheers!

Cite as:
Saad, T. "Lagrangian Optimization of Wall Injected Flows". Weblog entry from Please Make A Note. http://pleasemakeanote.blogspot.com/2009/10/lagrangian-optimization-of-wall.html

How to add space after \hline in LaTeX tables

Try the following:

\hline \\[-1.0em]

Voila!

Of course, you can change the numbers and units inside the brackets.

Cite as:
Saad, T. "How to add space after \hline in LaTeX tables". Weblog entry from Please Make A Note. http://pleasemakeanote.blogspot.com/2009/08/how-to-add-space-after-hline-in-latex.html

How to highlight text in LaTeX

Add the following to your preamble:

\usepackage{color}
\newcommand{\hilight}[1]{\colorbox{yellow}{#1}}

To highlight text in the body of your document, use

\hilight{this is some highlighted text}

Voila!

Of course, you can change the color from yellow to any of the supported colors. For a list of those, check: http://en.wikibooks.org/wiki/LaTeX/Colors

UPDATE:

There is a problem with the previous method is that the color box does not wrap properly. Here's a much easier and robust way of doing this

\usepackage{soul}

To highlight text in the body of your document, use

\hl{this is some highlighted text}

Cite as:
Saad, T. "How to highlight text in LaTeX". Weblog entry from Please Make A Note. http://pleasemakeanote.blogspot.com/2009/08/how-to-highlight-text-in-latex.html