douglasmiranda

Steps in Django for performing full-text search queries using unaccent extension

• Steps in Django for performing full-text search queries using unaccent extension
  • Disclaimer
  • Enable and configure unaccent extension on Postgres
    • Create a migration for enabling the unaccent extension
    • Configure your specific language in Postgres to use with unaccent
  • Example usage
  • Related links

douglasmiranda

TinyMCE will convert accents to HTML entities like:

à becomes á

So you see the problem there, you search in your database for "á" or even "a" (in case you are using unaccent), and you get nothing.

In my case, I was using full text search in Postgres, using the dictionary portuguese_unaccent (custom dictionary check here).

So keep in mind you can always make TinyMCE not convert stuff:

douglasmiranda

𝐀	A
𝗔	A
𝐴	A
𝘈	A
𝑨	A
𝘼	A
𝒜	A
𝙰	A
𝐁	B
𝗕	B

douglasmiranda

# IMPORTANT: Just keep in mind this is not ideal for untrusted JSON content.
import json

from django.contrib import admin

from .models import Publication


@admin.register(Publication)
class PublicationAdmin(admin.ModelAdmin):

douglasmiranda

# There are many ways to do it, like checking if "change" is in the current url path
# you can adapt to check for _changelist, _change, _delete...

def is_changelist_view(model_admin_instance, request):
    """
    Verify if the current view is changelist.

    Args:
        model_admin_instance (admin.ModelAdmin): ModelAdmin instance.
        request (HttpRequest): Current request.

douglasmiranda

FROM debian:bookworm
# Debian 12 (Bookworm)

# MS Fonts
ARG MS_FONTS_VERSION=3.8.1

RUN apt-get update && apt-get install --no-install-recommends -y \
    # Custom dependencies
    # ttf-mscorefonts-installer requires extra setup, adding contrib repo
    # that might generate conflict with other dependencies

douglasmiranda

{
	"Version": "2012-10-17",
	"Statement": [
		{
			"Sid": "PublicReadGetObject",
			"Effect": "Allow",
			"Principal": "*",
			"Action": "s3:GetObject",
			"Resource": "arn:aws:s3:::MY_BUCKET/*"
		},

douglasmiranda

services:
  django:
    # setup django container ...

  # Storage
  minio:
    image: minio/minio:latest
    ports:
      - 9000:9000
      - 9001:9001

douglasmiranda

Ansible for Configuration Management

I'm using Ansible only for Configuration Management, the server is up and I want to configure users, install packages and configure them.

For infrastructure provisioning terraform.io is nice!

Currently, my deployment flow includes Drone.io/GitlabCI for CI/CD and Docker Swarm for orchestrating containers.

• Ansible for Configuration Management
• Tasks

douglasmiranda

Update in 2024

So in 2024 in actually having a good time using mupdf.

About my experience with mupdf:

It's written in C, but you can use it in many ways. Command line, python lib (pymupdf), js, and others.

I still coundn't find issues that I had with other tools and weird broken PDFs, so I'd say pretty good.