database Archives - Page 3 of 73

WordPress

IT Nursery

How To Get Some Data From WordPress Database Using WordPress $wpdb Query?

I am trying to get some data from WordPress database tables in a plugin. For that, I am using the below code… global ...

June 3, 2022
0 Comments

Programming, sql

IT Nursery

How do I reset a sequence in Oracle?

In PostgreSQL, I can do something like this: ALTER SEQUENCE serial RESTART WITH 0; Is there an Oracle equivalent? 18 Answers 18

June 3, 2022
0 Comments

WordPress

IT Nursery

wp_redirection_404 table has grown to 7GB

The company I work for has an enterprise WordPress site that was acquired from a different company. I don’t know if there was ...

June 3, 2022
0 Comments

Programming, sql

IT Nursery

List all sequences in a Postgres db 8.1 with SQL

I’m converting a db from postgres to mysql. Since i cannot find a tool that does the trick itself, i’m going to convert ...

June 3, 2022
0 Comments

Database, Programming

IT Nursery

Storing time-series data, relational or non?

I am creating a system which polls devices for data on varying metrics such as CPU utilisation, disk utilisation, temperature etc. at (probably) ...

June 3, 2022
0 Comments

WordPress

IT Nursery

Is it good practice to use wpdb->query() function?

I am using custom php code to perform data insertion, deletion, updating and other tasks. I am able to insert data into a ...

June 3, 2022
0 Comments

WordPress

IT Nursery

Does WordPress MultiSite use separate MySql databases?

I ask because I cannot find the options from a plug-in I created on my second blog. Adding this plug-in to the main ...

June 3, 2022
0 Comments

WordPress

IT Nursery

If I delete plugins via FTP are settings kept in DB?

When I delete plugins via ftp (meaning all its files recursively) does WordPress remove its settings from the database? I want to delete ...

June 3, 2022
0 Comments

Java, Programming

IT Nursery

Is it possible to specify the schema when connecting to postgres with JDBC?

Is it possible? Can i specify it on the connection URL? How to do that? 8 Answers 8

June 2, 2022
0 Comments

WordPress

IT Nursery

Faulty restore of the database, encoding issue

I messed up the settings with W3 Total Cache (tried to import all the media to my library, didn’t work out well, broke ...

June 2, 2022
0 Comments