Abacadaba Web Development

Speeding up Wordpress by deleting all revisions.

The Wordpress db keeps all revisions.  If you have a large database (say 100,000 records) you can speed it up by deleting the revisions. The code for that is:

Your actual wp_posts table will have a name like wp_xd7tjs_posts. This is to improve Wordpress security. If your wp_posts is named wp_xd7tjs_posts then the code is:

Abacadaba.com is a web consulting company for Nik Bear Brown, a UCLA Computer Science PhD. Abacadaba.com does teaching, web development or data analysis/data mining jobs. Contact us at info@abacadaba.com if you have a web project that requires more machine learning, data mining, or text mining expertise that is typically found in web programmers.

Mr Brown’s UCLA Computer Science research focus is on knowledge aggregation for biomedicine. Knowledge aggregation involves Internet programming, machine learning, data mining, text mining, distributed algorithms, and Web search. His major field is Computational and Systems Biology and my minor fields are Artificial Intelligence and Statistics.

Nik Bear Brown – Partial CV (full CV availible upon request):

Education:

Ph.D. student in Computer Science, University of California, Los Angeles.
Fall 2007 to current. PhD expected Fall 2009.
GPA 3.6
M.S. in Computer Science, University of California, Los Angeles. December 2005. GPA 3.6
B.A. in Biochemistry and Molecular Biology, University of California, Santa Cruz

Fellowships:

NSF IGERT Fellow – Integrative Bioinformatics Training Program 2000-2003

Data Mining Skills :

Extensive experience in the analysis of gene expression data and the text mining of public data sources, data analysis and data mining. Strong database development and web development skills. I’ve used Python quite extensively in my own text mining research as well as for text mining/web robot and database development.

Web Developments Skills :

I’ve taught “Programming for the Internet” for UCLA’s Department of Mathematics (PIC40A), CS 31 Introduction to Computer Science I and CS 32 Introduction to Computer Science II (first and second quarter C++) for UCLA’s Department of Computer Science. I have extensive knowledge of: Python, C++, Objective-C (iPhone), Php, Perl, LAMP (Linux, Apache, MySQL and PHP/Python), SQL, web development frameworks (Zend Framework, Ruby on Rails, Symfony, Django), Php templating engines (Smarty, PHPTemplate, XTemplate), JavaScript libraries (Dojo, Mootools, Prototype, MochiKit, script.aculo.us, Yahoo! User Interface Library – YUI, Google Maps), version control (Git, Subversion, CVS), CSS, XHTML, Javascript, Php, Ajax, JSON, XML, XML Schema Development, XSLT, DTD’s, DOM and Web Standards.

Relevant Course Work:
Computer Science
UCLA Computer Science 118 – Networking
UCLA Computer Science 130 – Software Engineering
UCLA Computer Science 161 – Artificial Intelligence
UCLA Computer Science 180 – Algorithms
UCLA Computer Science 181 – Complexity & Automata
UCLA Computer Science 240 – Data Bases
UCLA Computer Science 249 – Data Mining
UCLA Computer Science 263A – Statistical Language Processing
UCLA Computer Science 263B – Connectionist Language Processing
UCLA Computer Science 268 – Machine Perception
UCLA Computer Science 269 – Artificial Intelligence
UCLA Computer Science 286L – Biological Modeling
UCLA Computer Science M296A – Mathematical Modeling in Medicine
UCLA Computer Science M296B – Optimal Parameter Estimation

Mathematics & Statistics
UCLA Mathematics 131A – Real Analysis
UCLA Mathematics 151A&B – Applied Numerical Methods
UCLA Statistics 165 – Data Mining
UCLA Mathematics 170A – Probability Theory
UCLA Statistics 180 – Bayesian Statistics
UCLA Biomathematics 203 – Stochastic Models in Biology
UCLA Statistics 216 – High Dimensional Data Analysis
UCLA Biomathematics 220 – Kinetic Steady State Models
Statistics M254 – Statistical Methods in Computational Biology
UCLA Mathematics 270A – Mathematics of Scientific Computing
UCLA Biostatistics 278 – Analysis of DNA Microarray Data

Biology & Chemistry
UCLA Chemistry 202 – Bioinformatics
UCLA Microbiology CM233 – Biotechnology
UCLA Microbiology CM234 – Ethics in Biomedical Research
UCLA Physiological Science 235 – Dynamical Systems Modeling
UCLA Human Genetics 236 – Advanced Human Genetics
UCLA Physiology 250C – Critical Topics in Physiology
UCLA Microbiology CM233 – Biotechnology
UCLA Chemistry M252– Advanced Methodology in Computational Biology
UCLA Pathology 255 – Mapping the Human Genome
UCLA Microbiology & Immunology M262A – Immunobiology of Cancer

Computer Skills:

Databases
Oracle (UCLA Extension Oracle 8 Database Administration Certification – Summer 2000)
Microsoft Access, SQL, ODBC, mySQL, PostgreSQL, UML, XML

Computer languages
HTML/XHTML/XML (7+ years experience)
Python (5+ years experience)
C++/C (5+ years experience)
Perl (5+ years experience)
Javascript (3+ years experience)
Php (3+ years experience)
Other langauges LSL (Linden Scripting Language), Ruby, Java, Lisp, ColdFusion, Shell Scripts, S-plus, R, MatLab

Software Design
I understand and develop requirements and design documents. I understand object-oriented programming, design patterns and service-oriented architectures.
Development IDE
Eclipse, Emacs, Notepad++
Operating Systems
Windows 9x/NT/XP, Macintosh, UNIX, Linux

Graphics
Extensive experience with Adobe Illustrator and Photoshop. SVG programming. ImageMagik, Apache Batik.

Other
I understand Ajax, XHTML, Javascript, DOM programming, Web Services, Service Oriented Architectures, MVC Architectures.