Persuming “article_datetime” to be a numeric value, I would suggest that instead of using ‘orderby’ => ‘meta_value’ use ‘orderby’ => ‘meta_value_num’ If still query is slow, than remove: ‘orderby’ => ‘meta_value’, ‘meta_key’ => ‘article_datetime’, ‘order’ => ‘DESC’ and instead sort the result in php.
No, you are not missing something. But you are using the wrong “framework” (which WordPress is not) for your use case, it seems. And you are mixing things up. What you are talking about, A.C.I.D. transactions, is by no means what you think it is for. ACID: save crash recovery (due to soft- or hardware … Read more
WordPress itself provides you with a function called register_new_user() which can be used to create a user-account in your WP instance. You will have to write some kind of integration between your Firebase DB and WordPress but this function would probably be the way to go.
There are a number of options that depend on your level of comfort with code and the number of changes you need to make. There are also a number of ways to achieve the same result. You mention partial migrations. If you can do that, go with it. That’s the fastest. I’m going to cover … Read more
Your JavaScript code works for me. The metadata do get saved. But perhaps you’d like to try my code which is pretty much completed, i.e. on page load, the checkbox is auto-checked/unchecked (and the text box is also shown/hidden) depending on the current database value. Secondly, I did it just as the Gutenberg team did … Read more
It all depends on your workflow. If you have no use for the post revisions and autosaves then disable them in wp-config and WordPress will clean them up on its own. You may also prefer to limit how many you keep at once. Also the space they take up is unlikely to be of a … Read more
I had to do something similar. What you need to do first is in each of your config files define the table prefix … make sure that they are different. Example: WordPress installation 1: wp123_ WordPress installation 2: wp124_ Your first installation would be your main installation the one with the user table you want … Read more
I don’t know if we are allowed to link to other answers but there is another question very similar to yours and the accepted answerer stated these things: You should be skeptical of anyone who says that there is a single “right” way. The right way depends on the situation. Using the CPT infrastructure has … Read more
If the code creating new tables uses dbDelta() (it should), you can filter the query (see wp-admin/includes/upgrade.php): add_filter( ‘dbdelta_create_queries’, function( Array $queries ) { foreach ( $queries as $table => $query ) { if ( FALSE !== stripos( $query, ‘CREATE TABLE’ ) ) { // change the query here } } return $queries; });
Actually, the customary way to do this in WordPress would be to use <?php update_post_meta($post_id, $meta_key, $meta_value, $prev_value); ?> as per the codex: https://codex.wordpress.org/Function_Reference/update_post_meta. It yields shorter code, and the intent of the code is clearer.