Braunson

function customConsoleTable(data) {
    // Handle GroupBy results by flattening them appropriately
    function flattenGroupBy(groupedData) {
        if (!groupedData || typeof groupedData !== 'object') return groupedData;
        
        // Check if this looks like a GroupBy result
        const isGroupByResult = Object.values(groupedData).every(Array.isArray);
        if (!isGroupByResult) return groupedData;
        
        // Flatten the grouped structure

Braunson

-- So you have an existing WP website with a prefix you need to change
-- We will need to do more than just updating the wp-config.php prefix.
-- There are row data that reference table names we'll need to update

-- Assuming we're already using the wp_ prefix and for example want to 
-- change to xyzwp_ we'll need to update the data within the tables

-- Update user meta references
UPDATE wp__usermeta 
SET meta_key = REPLACE(meta_key, 'wp_', 'xyzwp_') 

Braunson

<?php

/**
 * Class WP_Geekybeaver_Theme_Settings
 *
 * Configure the plugin settings page.
 */
class WP_Geekybeaver_Theme_Settings
{
	/**

Braunson

{
	"scripts": {
		"post-install-cmd": [
			"@php -r \"file_exists('.env') || copy('.env.example', '.env');\"",
			"@php -r \"if (strlen(trim(file_get_contents('.env'))) > 0 && !preg_match('/^APP_KEY=.+/m', file_get_contents('.env'))) { echo shell_exec('php artisan key:generate --ansi'); }\"",
			"@php -r \"file_exists('database/database.sqlite') || touch('database/database.sqlite');\""
		]
	}
}

Braunson

AWS_ACCESS_KEY_ID=sail
AWS_SECRET_ACCESS_KEY=password
AWS_DEFAULT_REGION=us-east-1
AWS_BUCKET=local
AWS_ENDPOINT=http://minio:9000
AWS_USE_PATH_STYLE_ENDPOINT=true

Braunson

source .env

mysql -N --raw --batch \
    -h"${DB_HOST}" -u"${DB_USERNAME}" -p"${DB_PASSWORD}" "${DB_DATABASE}" \
    -e "SELECT uuid FROM failed_jobs ORDER BY id DESC LIMIT 100000" | \
xargs -P 4 -n 100 php /var/www/html/artisan queue:retry

Braunson

# Add the following line to create a new container for a Typesense Dashboard
# It's accessible at laravel.test:81
typesense-dashboard:
    image: ghcr.io/bfritscher/typesense-dashboard:latest
    restart: always
    ports:
          - "81:80"
    networks:
        - sail

Braunson

{{-- Drop this under @livewireScripts in your layout --}}
@if (app()->environment() == 'local')
    <script>
        document.addEventListener("livewire:init", function(event) {
            Livewire.hook('component.init', ({ component, cleanup }) => {
                console.log("%cComponent: " + component.name, "font-weight:bold");
                console.log(component.snapshot.data);
            });
        });
    </script>

Braunson

Optimizing a complex query in Laravel

The Issue

In one of my recent projects, I encountered a significant performance issue (with some digging found out this was due to a slow-running query) in an existing Laravel application. The application relied heavily on a query that fetched data from multiple related tables, causing delays and affecting user experience.

The Challenge

The challenge was to find the affecting queries and optimize them to improve performance witout affecitng the accuracy or integrity of the data.

Approach

Braunson

const ifcLoader = new OBC.FragmentIfcLoader(component)

ifcLoader.onIfcLoaded.add(() => {
    // Create a new div element with the desired content
    const messageDiv: HTMLDivElement = document.createElement('div');
    messageDiv.textContent = 'Loaded the component';
    messageDiv.style.position = 'fixed';
    messageDiv.style.bottom = '10px';
    messageDiv.style.left = '10px';
    messageDiv.style.backgroundColor = 'lightgreen';