SQLite Jobs

We need a Python-based automation system to monitor and process ~10 airline bookings/PNRs per day using Amadeus (read-only operations). Core Requirements: * Automate login and navigation in Amadeus using Playwright (browser automation) * Scan PNR queues and extract booking/fare details * Identify ticketed vs unticketed PNRs * Run scheduled checks (cron or background worker) * Store data in a database (SQLite or PostgreSQL) * Generate simple reports (Excel or dashboard optional) Technical Stack: * Python (core backend logic) * Playwright (browser automation) * PostgreSQL/SQLite (data storage) * Optional: FastAPI for API/dashboard * Optional: LLM integration for edge-case interpretation Scope: * Small-scale system (~10 PNRs/day) * Read-only automation only (no ticketing, cancellation, ...

I have started a roster of PKL participants along with the kind of transport they use—motorbike or public transportation—but it is incomplete. I need you to turn it into a neatly ordered, fully populated text file (.txt, UTF-8). Each entry must follow this structure: Name | Transport Type | Address You may stage the data in SQLite while working; that is the database format I am most comfortable reviewing should I ever need to expand or import the list later. However, the final hand-off must still be a plain text file. What you will do: • Use the twelve names I have already given as the starting point. • Fill in any missing numbering, fix obvious typos, and keep the transport notes exactly as stated (Motorcycle, GL Motorcycle, etc.). • Research or req...

I need a compact Windows desktop application that pulls equity and derivative market data every minute from the APIs I currently rely on—Dhan, Fyers and Zerodha—while leaving room to drop in Truedata or any other reliable feed later. The program must: • Stream and store both real-time ticks and end-of-day OHLCVOI in a local database (SQLite or PostgreSQL, whichever you recommend for speed and stability). • Expose the stored data through a lightweight interface my existing Python-based algo engine can query with minimal latency. • Simultaneously push the live stream to a separate Python charting module so I can view candles forming in real time. • After the closing bell, run an automated reconciliation that compares OHLCVOI from at least three sources ...

Title: Python Data Engineer for Anna's Archive Metadata Pipeline, Book Deduplication & RAG Dataset Preparation Project Overview We are building a large-scale book and knowledge ingestion pipeline for an AI-powered RAG (Retrieval Augmented Generation) platform. The freelancer will be responsible for setting up the complete pipeline, starting from Anna's Archive metadata dumps through deduplication, content extraction, chunking, and preparation of a clean corpus ready for embeddings and vector database ingestion. Scope of Work 1. Download and process Anna's Archive metadata dumps: * LibGen RS * LibGen Fiction * Magazines * Sci-Hub / Scientific Articles 2. Build metadata ingestion pipeline: * Parse large JSON/JSONL/GZ/ZST files * Create efficient s...

I need an Android-only app that stops the endless scroll on Facebook, Instagram and TikTok, while giving users a live view of exactly how long they spend on each of those platforms. The core idea is simple: whenever the user activates Focus Mode inside the app, vertical scrolling, shorts, reels or any other auto-play feed in the three selected social media apps must be completely blocked until the timer ends or the user explicitly unlocks it with a PIN. Real-time tracking is essential. The moment any of the three apps comes to the foreground, a counter should start and update on a small overlay or notification, then roll straight into a dashboard that shows current session length, total time today and historical charts. No scheduled daily or weekly batches—everything updates instant...

## Project Description Develop a secure cross-device synchronization system for an existing React web application and React Native mobile application. The applications store machine-learning generated data locally, including face embeddings, vector embeddings, media metadata, and versioning information using IndexedDB (Web) and SQLite (Mobile). The objective is to enable automatic synchronization of data between a user's authorized devices while minimizing network usage and avoiding full database transfers. The solution should support Web-to-Mobile, Mobile-to-Web, and Mobile-to-Mobile synchronization through efficient device discovery and bi-directional data exchange within the LAN/Wifi network. The synchronization process must transfer only new or updated records, prevent duplicat...

I need an Android-only app that stops the endless scroll on Facebook, Instagram and TikTok, while giving users a live view of exactly how long they spend on each of those platforms. The core idea is simple: whenever the user activates Focus Mode inside the app, vertical scrolling, shorts, reels or any other auto-play feed in the three selected social media apps must be completely blocked until the timer ends or the user explicitly unlocks it with a PIN. Real-time tracking is essential. The moment any of the three apps comes to the foreground, a counter should start and update on a small overlay or notification, then roll straight into a dashboard that shows current session length, total time today and historical charts. No scheduled daily or weekly batches—everything updates instant...

I’m looking to have a small, focused web project built that lets users create and edit their own playlists directly in-browser. The core of the job is straightforward website development rather than a full-scale app: a clean interface where tracks can be added, reordered, renamed, or removed, with changes stored instantly. Here’s what I need accomplished: • A lightweight front-end (plain HTML/CSS/JavaScript or a modern framework if you prefer) showing the playlist and its controls. • Simple back-end logic to persist the playlist data—SQLite, Firebase, or any equally uncomplicated solution is fine as long as it keeps the project easy to deploy. • Basic user flow: open the page, see the current playlist, click to add a new item (title + optional link), d...

# REQUEST FOR PROPOSAL (RFP) # STAND-ALONE HOUSEHOLD GOODS MOVING COMPANY MANAGEMENT SOFTWARE ## Project Overview We are seeking a stand-alone desktop software solution specifically designed for a Household Goods Moving Company. The system must manage the entire shipment lifecycle from booking through final delivery, invoicing, collections, reporting, and profitability analysis. The software should be optimized for military, National Van Lines (NVL), NFC, COD, interstate, intrastate, and warehouse/storage shipments. The system must significantly reduce manual data entry by utilizing OCR and AI technology to scan trip sheets, bills of lading, and registration documents and automatically populate shipment records. --- # 1. CUSTOMER MANAGEMENT The software shall maintain a complete cu...