Sophia Parafina articles - 29 total
Txt-to-SQL: Querying Databases with Nebius AI Studio and Agents (part 3)
Maximum effort! Not really. We're building an agent to query the database for this installment. It...
Text-to-SQL: Generating SQL with Nebius AI Studio (part 2)
In the previous post, we created documents based on the tables in the Northwind Trader database. We...
Text-to-SQL: Creating Embeddings with Nebius AI Studio (part 1)
Nebius AI Studio is an inference service offering state-of-the-art open-source large language models....
Data Engineering with DLT and REST
Building a Data Pipeline with DLT In this example, a company provides IoT data through a...
SaSS-ify with Jigsaw Stack
Jigsaw Stack's API provides various services, such as web scraping and LLM prompting. I tried out the...
autollama
From the ollama help discord channel: Docker compose: How do you pull a model automatically with...
RAG with Web Search
Retrieval augmented generation (RAG) is a popular way to use current or proprietary data with Large...
RAG Step-by-Step: Open Source Edition
In a previous post, I demonstrated how to implement RAG using the Load-Transform-Embed-Store...
A RAG Client
In the previous post, we went through the steps to build a backend for an RAG application. This is...
RAG Step-by-Step
Frank Denneman of VMWare recently published RAG Architecture Deep Dive which defines the process for...
Build a GPU Enabled Llamafile Container
It's been fun playing with LLMs with a CPU. However, the novelty wears off as I watch the completion...
Building and Running llamafile with a GPU
Getting llamafile running with a GPU can be a little tricky. For reference, I have a four-year-old...
A Quick Guide to Containerizing Llamafile
Llamafile is a Mozilla project that runs open source Large Language Models such as Llama-2-7B,...
Local AI
Local AI is the ability to run artificial intelligence models on commodity hardware. Many models can...
Installing Hugging Face on an M2 macOS Machine
If you are installing Hugging Face transformers on a M2 macOS machine, you might run into this...
What You Need to Know About Securing Wordpress On AWS Lightsail
There are many articles about securing your Wordpress site running on AWS Lightsail. Some information...
Jupyter and bash, better than peanut butter and chocolate
As a developer advocate, I fall into the "show me" camp. That means I like to show code when writing...
Where Is Everyone? The Global Impact of COVID on Road Traffic
Slides from a 4 minute lightning talk at FOSS4G2022 in Firenze, IT. HERE Traffic Analytics provide...
Mapping Earthquakes in the Permian Basin
When I read an article about earthquakes caused by fracking in west Texas, I wanted to map the data....
Handling Out of Process API requests
When we work with APIs, we typically work with a request-response pattern or a streaming pattern....
Using Gitlab to deploy a Github repository to AWS
Github is a great way to collaborate on code. However, I use Gitlab as a CI/CD to deploy application...
Speeding up geodata processing with feather
Previously, on speeding up geodata processing... In this post, I compare the read and write...
Speeding up geodata processing
I've been using the excellent geopandas for working with largish geodata sets and CSV files. While...
Getting Started with YOLTv4 for Object Detection in Imagery: Getting Training Data
This is the second article in a series of tutorials that attempt to fill gaps in this excellent...
Getting Started with YOLTv4 for Object Detection in Imagery: Part 1
This tutorial attempts to fill gaps in this excellent article: Announcing YOLTv4: Improved Satellite...
Securing Infrastructure: Build a Bastion Host
Protecting your infrastructure begins with controlling access to cloud resources. You can reduce the...
Deploying Minecraft on Azure
There are several parts to the process. First, we need to create the network resources to make the vi...
Build a VS Code Devcontainer for Infrastructure as Code
One of the major advantages of using containers for development is reducing the need to install softw...
Free resources for building multi-cloud infrastructure.
Successful modern cloud application deployments are influenced by factors outside of technology choi...