jaykrown

About | Posts

Tag: python

  • Creating and querying a database with DuckDB

    —

    by

    jaykrown
    in

    This was a basic test using DuckDB and Python to create and query a database. The repository is here: https://github.com/jaymasl/duckdb-create-database. First database-create.py creates a table and takes in a movie-data.csv, it then cleans the Budget and Revenue to be formatted as FLOAT datatype: Then database-query.py queries the database to find all the movies between the…

  • Image Similarity App

    —

    by

    jaykrown
    in

    I have successfully created my first functional Flask app which is now live on my website at the subdomain https://app.jaykrown.com. The application accepts two image uploads and returns a percentage based on the similarity of the two images. If you upload the same image twice it will always return 100%. If you upload an image…

  • Detect image similarity

    —

    by

    jaykrown
    in

    This outlines my experience using AI to aid me in writing a Python script that determines the raw similarity of two images. Prompt: Python script:

  • Extract prompt from EXIF with Reg Ex

    —

    by

    jaykrown
    in

    This is a process starting with an AI image generated using ComfyUI and extracting the prompt into a JSON format using Python. This demonstrates my understanding of fundamental concepts such as regular expressions, different file formats, and python syntax. Python script: Output:

  • Create database + import CSV

    —

    by

    jaykrown
    in

    This post explains the process of prompting AI to generate Python code which creates a database and then imports a CSV file into the database. The database can then be queried using sqlite3. This process can be applied to many different applications. https://github.com/jaymasl/create_database Python script: data.csv: console output: