aldolat + database   21

Direct Database Queries, Part 1 | Tom McFarlin
This is not the first time I’ve mentioned this, but one of the challenges that come with talking about writing direct database queries to update information in the WordPress database is that you leave yourself open to something like: "Yeah, but there’s an API to do something just like that." And, in many cases, that’s right. I’m a big fan of using ’em, too. But there are times where direct, parameterized database queries can be a more optimal choice.
WordPress  database  query  from instapaper
15 days ago by aldolat
VisiData is an open source supertool for exploring and manipulating data. It combines the clarity of a spreadsheet, the efficiency of the terminal, and the power of Python, into a lightweight utility which can handle millions of rows with ease.
spreadsheet  data  database 
december 2018 by aldolat
WordPress Table Prefix: Changing It Does Nothing to Improve Security
Changing your WordPress table prefix is risky to implement and it does absolutely nothing to enhance your site security. In today’s post I’m going to explain what the original idea is behind this and why you should simply not do it.
WordPress  security  database  prefix 
december 2016 by aldolat
WordPress Essentials: Interacting With The WordPress Database - Smashing WordPress
In this article, I will show you how to get started with the $wpdb class, how to retrieve data from your WordPress database and how to run more advanced queries that update or delete something in the database. The techniques here will remove some of the constraints that you run into with functions such as get_posts() and wp_list_categories(), allowing you to tailor queries to your particular needs. This method can also make your website more efficient by getting only the data that you need - nothing more, nothing less.
wordpress  database 
september 2011 by aldolat
Clean Up Weird Characters in Database | Digging into WordPress
Then to clean up these weird characters from the WordPress database, use a program like phpMyAdmin to execute the following queries.
wordpress  database  mysql  phpmyadmin 
july 2011 by aldolat
BigDump: Staggered MySQL Dump Importer
Staggered import of large and very large MySQL Dumps (like phpMyAdmin 2.x dumps) even through the web servers with hard runtime limit and those in safe mode. The script executes only a small part of the huge dump and restarts itself. The next session starts where the last was stopped.
mysql  database  import  php 
may 2011 by aldolat
Version 2.3.2 « WordPress Codex
Can create a custom DB error page at wp-content/db-error.php. This is displayed when WordPress, for whatever reason, can't connect to the database.
wordpress  db-error  database  errors  mysql 
may 2011 by aldolat
Printer List | OpenPrinting - The Linux Foundation
Please choose a printer manufacturer to search for. If you know the specific printer model you would like to view, select the model number from the list as well. Otherwise, choose the "show all" option and all printers made by the selected manufacturer will be listed on your screen.
linux  printer  database  compatibility 
january 2011 by aldolat
Sanitize Database Inputs
Function for stripping out malicious bits.
php  html  javascript  database  security  xss 
november 2010 by aldolat
Change Your Database Prefix to Improve Security | Digging into WordPress
One of the smartest ways to protect your site’s database is to change the default table prefix to something obscure and difficult to guess. Sort of like a password.
wordpress  database  security 
october 2010 by aldolat
Database Powered CSS in WordPress Themes | Joseph Scott
A popular ability in WordPress themes is to add custom CSS driven by options. This brings up a common question, how should the theme inject custom CSS? I’ll outline three different approaches on how to do this. These aren’t new, many people have written about these; forums, blog posts, email lists and IRC. I’m still seeing questions about this though, so I wanted to address this specific question with specific solutions.
wordpress  themes  css  database 
april 2010 by aldolat
WordPress Support - Remove custom Fields from
Come cancellare i custom fields non più utilizzati
wordpress  tips  phpmyadmin  Database 
may 2009 by aldolat

Copy this bookmark: