SQLite Jobs

I need the pin-to-keep behaviour added to my existing Android text-clip list. A user should be able to touch-and-hold any text clip in the RecyclerView; that gesture toggles a “pinned” state. Pinned clips remain in the local Room/SQLite store indefinitely, while every unpinned clip should be purged exactly one hour after its creation time. I’m fine with the standard Android UI conventions—think long-press selection, a pin icon in the contextual action bar, and a small pinned indicator inside each row. No custom assets are required beyond the built-in Material icons. The current codebase is Kotlin, minSdk 24, using ViewModel + LiveData. Please stay within that stack. If you see a cleaner Jetpack-recommended way to schedule the one-hour expiry (WorkManager or AlarmM...

I am building a React Native or Flutter driver application—think Uber’s driver app, but with no payment or passenger-matching logic. The core requirement is a smooth integration with Waze for turn-by-turn navigation, wrapped inside a secure, professional-grade driver experience. The scope in a nutshell • Account & authentication: drivers create a profile that they can unlock via Face ID, password or fingerprint. During first-time setup the Face ID photo must be matched against the photo on the driver’s license (you may rely on any reliable on-device comparison API or a lightweight server call—open to your recommendation). • Daily workflow: once logged in, the driver starts a “shift”, completes a short pre-trip vehicle checklist, and is...

We need a simple, localized web-based portal for a trucking company to verify that drivers are picking up the correct trailers. The system will generate a QR code at dispatch which security will later scan at the gate to confirm the trailer number against their physical observations. Scope of Work Dispatcher Dashboard (The Generator): A simple web interface for dispatchers to enter: Driver Name, Truck #, and Trailer #. Action: System generates a unique record in a local database and produces a printable QR code. The QR code should encode a URL pointing to that specific record on the local network. Security Gate Portal (The Verifier): A "Security View" optimized for tablets or rugged PCs. When security scans the driver's QR code, the portal must instantly display the Expected...

Project Description: I am looking for an experienced Flutter developer to build a PPG (Photoplethysmography) mobile application. I already have a fully functional web-based version (Javascript/Browser) that captures pulse and stress levels via the webcam. I need this ported to a native Flutter app to achieve medical-grade accuracy using better hardware control. The Goal: Turn the phone’s camera and flashlight into a sensor to measure: Heart Rate (BPM) HRV (Heart Rate Variability - SDNN) Stress Index based on RR-Intervals. Key Deliverables: Camera Sensor Module: Implement the Flutter camera package to stream raw image data. Crucial: Must handle "Torch Mode" (Flashlight ON) and Lock Exposure/White Balance to prevent signal noise. ...

We’re looking for a skilled full-stack developer to provide part-time, ongoing engineering support for an evolving product. The work focuses on incremental improvements rather than a one-time build, including frontend UI enhancements, admin panel updates, backend logic updates using Python, and API integrations with internal and third-party services. Experience working across both frontend and backend systems, including Python-based backends with REST/JSON APIs and relational databases (such as SQLite or PostgreSQL). On the frontend, familiarity with Svelte, TypeScript, and modern CSS frameworks like Tailwind CSS is a plus. The pay rate is open right now so please provide your proposed pay rate. As the product grows, support may scale or expand to additional resources to help acce...

Our ALFRED capstone project is almost feature-complete: the JavaFX desktop UI is in place, the core algorithm runs in Python, and an SQLite file stores everything. The weak link is the layer that moves data smoothly between these pieces. I will hand over: • the ERD and all schema scripts • the current DAO / repository classes in Java • the Python modules that read-write through sqlite3 • a short workflow document that maps every UI action to its expected database touchpoints Your mission is to tighten that pipeline. Make the UI’s requests reach the Python logic, make the logic persist results without race conditions, and return fresh data to the interface instantly. Along the way, refine any clumsy statements—sub-queries, joins, or missing inde...

I’m looking to collaborate with developers for building a Hospital Management System using the following stack: Backend: Flask Frontend: Vue.js + Bootstrap Database: SQLite Caching: Redis Background Jobs: Celery + Redis This is a multi-user web application with role-based access and modular features (similar to real-world management systems). The project structure, documentation, and wireframes are already prepared and will be shared once we connect. Clean, plagiarism-free code (mandatory) Project must be developed from scratch AI tools can be used for assistance, but copied or reused projects are not acceptable Would prefer Indians. If you’re interested, please connect with me. I’ll share the detailed documentation and wireframes before we proceed further.

I need a forensic specialist ideally based in Ho Chi Minh City to pull every scrap of data still living inside Zalo’s local SQLite stores on a Windows laptop. The focus is narrow and clear: recover all text messages plus any contact information linked to those chats; photos, videos, and other media can be ignored for now. You’re free to work with Magnet AXIOM, Cellebrite, Autopsy, X-Ways, or your own Python / sqlite3 scripts—whatever lets you prove the chain of custody and export clean, searchable tables. Deliverables • CSV or XLSX of every recovered message with timestamp, sender/receiver IDs, and thread reference • CSV or XLSX of the full contact list (UID, display name, phone/email where available) • A brief but reproducible methodology report d...

I need a skilled analyst who can dive into my sales data and surface clear, time-based trends using a mix of SQL and Python. The raw figures sit in a relational database; from there you’ll write efficient SQL queries, pull the results into Python (pandas, NumPy, SQLAlchemy), tidy everything, then explore daily, weekly, and monthly patterns. Visualisations in matplotlib or seaborn and a concise written summary (PDF or Jupyter Notebook) will round out the story so stakeholders can quickly grasp how revenue is evolving and where seasonality or anomalies appear. Deliverables • Well-commented SQL scripts that reproduce the dataset • A Python notebook (or .py script) with all transformation and analysis steps • Three to five clear charts illustrating sales trends over...

Our repair shop handles a steady flow of damaged distribution transformers and I need a Windows-based desktop program that ties the whole workflow together. The software must open with an intake screen where I log each incoming unit—basic make & model data, KVA rating, reported fault etc. From there the system should guide the transformer through every stage of repair: • Repair process tracking – define job cards, assign technicians, attach test readings and spare-parts consumption, then mark the job ready for inspection only if all mandatory fields are closed. • Inspection scheduling – create Stage-1 and Stage-2 inspection slots, print or email call-letters, and store the inspector’s pass/fail remarks alongside test certificates. A dashboard view ...

I need the pin-to-keep behaviour added to my existing Android text-clip list. A user should be able to touch-and-hold any text clip in the RecyclerView; that gesture toggles a “pinned” state. Pinned clips remain in the local Room/SQLite store indefinitely, while every unpinned clip should be purged exactly one hour after its creation time. I’m fine with the standard Android UI conventions—think long-press selection, a pin icon in the contextual action bar, and a small pinned indicator inside each row. No custom assets are required beyond the built-in Material icons. The current codebase is Kotlin, minSdk 24, using ViewModel + LiveData. Please stay within that stack. If you see a cleaner Jetpack-recommended way to schedule the one-hour expiry (WorkManager or AlarmM...

I need the pin-to-keep behaviour added to my existing Android text-clip list. A user should be able to touch-and-hold any text clip in the RecyclerView; that gesture toggles a “pinned” state. Pinned clips remain in the local Room/SQLite store indefinitely, while every unpinned clip should be purged exactly one hour after its creation time. I’m fine with the standard Android UI conventions—think long-press selection, a pin icon in the contextual action bar, and a small pinned indicator inside each row. No custom assets are required beyond the built-in Material icons. The current codebase is Kotlin, minSdk 24, using ViewModel + LiveData. Please stay within that stack. If you see a cleaner Jetpack-recommended way to schedule the one-hour expiry (WorkManager or AlarmM...

I'm a fundamental analyst looking to automate my trading strategy to improve discipline and consistency. I have a clear trading logic documented and need a developer to build a clean, reliable system that can run on my local machine. What I Need: A personal trading automation tool that helps me execute my strategy systematically, not a commercial product or institutional platform. What We're Building A personal trading assistant that: 1. Monitors my watchlist of 30-50 stocks 2. Automates entry/exit decisions based on my rules 3. Shows real-time charts and portfolio status 4. Manages risk with simple safety rules 5. Runs reliably on my computer Technology Requirements Essential Stack · Backend: FastAPI (for async handling) · Database: SQLite (with basic persis...

I need a clean, stable Android application that plugs into our existing school ERP database and splits the experience across three roles. Student panel • View fees status in real time, synced with our ERP ledger • Access timetable with day-wise periods pulled from the central schedule Teacher panel • Upload study materials (PDF, PPT, video) to the correct class or section • Send announcements that trigger push notifications and store in an inbox Admin panel • Manage fees collection with dashboard totals, filters by class and date, and one-tap reconciliation • Access profit & loss reports generated from the same fees data and other expense inputs • Manage teacher and student data—add, edit, deactivate, or bulk-import records ...

Our stock is still tracked in a handwritten ledger, but I’m ready to retire the calculator. I will key the current balances into a simple digital file—CSV or Excel, whichever you find easier to parse—and hand that to your program. From there I need a compact, well-documented Python solution that walks me through three day-to-day actions straight from the terminal or a lightweight Tkinter/Qt window: • Issue: select an approved voucher, have the script reduce on-hand quantities and adjust average cost immediately. • Return: post items back into stock with the correct quantity and value adjustments. • Stock-take: at year-end the module should highlight any count discrepancies and apply straight-line depreciation before showing the revised valuations. All...

I’m commissioning a stripped-down, proof-of-concept chat app for Android that works even when the device is offline. The goal of this first milestone is to establish the technical backbone—not visual polish—so I can quickly validate the product idea and iterate later. Key scope • Single platform: Android (phone and tablet). • Data strategy: everything—account details, message threads, pending outbound messages—must persist locally in an encrypted SQLite / Room database and sync automatically once a connection is restored. • On-boarding & auth: users identify themselves with their phone number only; verification via SMS OTP or similar is acceptable. No email or social login for now. • Core interaction: one-to-one text messaging....

A streamlined WhatsApp chat solution written in Python is the goal. The code will live on my Ubuntu 22.04 VPS and must let me programmatically send, receive, and log WhatsApp messages from an existing Business account. Reliability comes first; every outbound message needs an acknowledgement callback and every inbound message should be captured in a local SQLite or PostgreSQL table for later reporting. Scope highlights • Clean Python 3.x code that wraps the official WhatsApp Business Cloud API (or another compliant gateway if you can justify it) • Simple CLI or minimal Flask/FastAPI endpoint to trigger messages with parameters: recipient, template/body, media (optional) • Webhook listener that records incoming messages, delivery receipts, and errors to the database and...

Necesito crear un flujo automatizado que recolecte información desde bases de datos académicas sobre un tema específico, valide su exactitud por comparación de fuentes múltiples y la guarde en una base SQL estructurada. Alcance • Desarrollar un script en Python que rastree, extraiga y normalice datos académicos. • Validar cada registro con cruces automáticos entre al menos dos fuentes para reducir errores. • Cargar los resultados –texto y números– en tablas claras, con claves primarias y relaciones bien definidas. • Generar reportes de control de calidad en Excel o Google Sheets que muestren discrepancias y registros pendientes de revisión. • Implementar un mecanismo de actualizaci&...