Sqliteproiecte
...diferite); 6. Implementarea și utilizarea unor operații asincrone; 7. Utilizarea claselor pentru accesul la resurse externe (din rețea); 8. Prelucrarea de fișiere JSON. Fișierele trebuie să conțină cel puțin 3 noduri dispuse pe niveluri diferite. Fiecare nod trebuie sa aibă cel puțin 3 atribute; 9. Utilizarea fișierelor de preferințe. Atât scriere cât și citire; 10. Crearea unei baze de date SQLite cu minim două tabele cu legături între ele. Implementarea operațiilor de tip DDL; 11. Implementarea operațiilor de tip DML. Pentru fiecare tabela să se implementeze cel puțin o clasă de acces la date care să includă metode de inserare, modificare și ștergere. Toate metodele trebuie apelate; 12. Definirea a minim două rapoarte (afișarea în activități) a in...
Am de realizat o aplicatie de tip client-server TCP/IP cu un scenariu la libera alegere. Serverul va avea o metodă de inițializare prin care va citi la lansare datele aplicației din fișiere text și le va salva într-o tabelă a unei baze de date sqlite. De asemenea datele vor fi memorate și în colecții de tip List, Set sau Map. 2. Serverul va răspunde cerințelor clientului în regim multi-threading. Vor fi cel puțin două solicitări din partea clientului. La cel puțin una din solicitări va răspunde utilizând colecțiile, prin prelucrarea funcțională a colecțiilor, iar la celelalte prin interogări directe în baza de date. 3. Serverul va funcționa până când va fi oprit în mod voluntar printr-un semnal de la client sau prin interfața gra...
Am de realizat o aplicatie de tip client-server TCP/IP cu un scenariu la libera alegere. Serverul va avea o metodă de inițializare prin care va citi la lansare datele aplicației din fișiere text și le va salva într-o tabelă a unei baze de date sqlite. De asemenea datele vor fi memorate și în colecții de tip List, Set sau Map. 2. Serverul va răspunde cerințelor clientului în regim multi-threading. Vor fi cel puțin două solicitări din partea clientului. La cel puțin una din solicitări va răspunde utilizând colecțiile, prin prelucrarea funcțională a colecțiilor, iar la celelalte prin interogări directe în baza de date. 3. Serverul va funcționa până când va fi oprit în mod voluntar printr-un semnal de la client sau prin interfața grafică...
...Encryption: Encrypted local database to protect sensitive business data. D. Reporting & Back-Office ● ● Automated EOD: End-of-day (X/Z) reports generated locally. Cloud Dashboard: Centralized web view for owners to monitor multiple branches. ● Exporting: One-click exports for accounting (CSV, Excel, PDF). 3. Technical Requirements ● ● ● ● Architecture: Offline-first using a local database (e.g., SQLite, Realm, or PouchDB). Front-End: Modern, responsive framework (e.g., React/Electron, Flutter, or .NET MAUI). Back-End (Cloud): Secure API (Node.js, Python, or Go) with a robust database (PostgreSQL/MongoDB). Hardware Compatibility: Standard Windows/Android drivers for retail peripherals. 4. Deliverables ● ● ● ● Fully Functional Application: Compiled installer for the target OS (...
...sistema que capture: • GCLID • Keyword • Campaña • Grupo de anuncios Opciones válidas: • Uso de número de reenvío de Google • Captura GCLID en formulario y almacenamiento en base de datos • Asociación del GCLID con número llamante Se debe almacenar en base de datos: • Fecha llamada • Teléfono • GCLID • Keyword • Campaña • Duración Base de datos aceptada: • MySQL • PostgreSQL • SQLite (si es ligera) ⸻ FASE 2 – Análisis automático de conversación El sistema debe: 1. Detectar nueva llamada desde API de Zadarma. 2. Obtener grabación o transcripción. 3. Enviar transcripció...
Hi! I am looking to upgrade my current sales dashboard. I am looking for a Data Specialist who I can learn from and who can propose...from CSV files. I need a place where I can import that data to. I would like the dashboard to be as detailed as possible showing multiple KPIs, graphs, and correlations between the various data. Once setup, I would like it to be fairly simple to import new data, and modify the dashboard as needed over time. I would like this setup to be fully offline and local. My current thoughts are Metabase + SQLite. However I am open to other solutions and recommendations. I will be able to provide an example of the CSV during discussion to see how and what we can achieve with the data. I am looking for an individual who I can work with long term as my Data S...
I want a lean, dependable Android app that helps me log day-to-day sales without any bells and whistles. The flow is fixed at four material-designed screens: 1. Company creation 2. Product creation 3. Sales / POS entry 4. Report & Export Everything may live in a local SQLite (or similarly lightweight) database so figures stay put between sessions. Jetpack libraries are welcome if they speed things up. Deliverables I expect • Complete Android Studio project with tidy, well-commented code • Signed APK that installs on Android 9+ • Short README describing how to build, where the data sits, and how to trigger the CSV/email export If the compiled APK mirrors the four-step flow above, stores data reliably, and can push out a CSV or email attachment of ...
I need an experienced Python trading-bot developer to optimize and refactor a live async trading bot connected to REST & WebSocket APIs, which currently slows under load and misses ticks/orders. The task includes profiling bottlenecks, improving async/WebSocket performance, optimizing pandas & SQLite usage, and ensuring real-time execution. Goal: <200 ms tick-to-order latency, zero missed ticks, clean refactored code, tests, and one-command VPS setup.
...Desktop side must run on Windows at minimum; cross-platform (Electron, .NET MAUI, or similar) would be a bonus. • Clean, intuitive UI with charts, trend lines, and colour-coded alerts. • Ability to push configuration commands back to the devices—for example, change sampling frequency or trigger a fan/ventilation relay if air quality drops below a set level. • Data should be persisted locally (SQLite or LiteDB is fine) and optionally mirrored to the cloud for remote access. Deliverables 1. Fully commented source code for both the firmware (if you supply sample sensor firmware), cloud or broker layer, and the desktop application. 2. Build/run instructions and an installable desktop package. 3. A short write-up describing how to extend the system ...
...present the project from a single, self-contained workspace (code, data and notebook if needed). Tech notes AI Studio can host standard web stacks, so feel free to work in React, Vue, plain Django templates, or another lightweight framework—just keep dependencies reasonable so the environment launches quickly. Client-side state management is fine, but server-side persistence (even a simple SQLite or JSON store) is required so the demo survives a page refresh. Deliverables 1. Complete source code with clear folder structure. 2. AI Studio project file / workspace export ready to import. 3. A short README that explains how to start the app, add new products and change colours or sizes. 4. One-click (or single command) launch script so my tutor can evaluate with...
...cash handling, etc. Optional online features for some customers: Cloud or remote reporting dashboards Remote backups/sync (multi-site optional) Online ordering integrations (where requested) Exports/automations to accounting or ERP (optional) Technical requirements Real-time sync on LAN (target <1s) using WebSockets/events or equivalent Offline queue + retry + conflict handling Local DB (SQLite/MySQL/Postgres) + backups/restore + audit trail Clear device configuration + diagnostics screen (device status/log export) Easy deployment: installer or start/stop scripts, auto-start services on Windows Required skills / competencies Proven experience building POS systems (hospitality and/or retail) Real-time systems + offline-first design (sync, retries, conflict resoluti...
...slows, misses price ticks and occasionally skips orders, so I need a clean performance tune-up and code review. Your task is to comb through the existing modules—order manager, data streamer, and strategy loop—identify the bottlenecks, then fix or refactor as needed so the bot reacts in real time without dropping trades. Expect to work with async I/O, websockets, pandas dataframes and a small SQLite trade log. Deliverables • Refactored, well-commented Python code with any slow sections profiled and optimised • A brief report that explains each change, shows before/after latency benchmarks, and lists test results on both sandbox and live endpoints • Updated and a one-command setup script so I can spin the bot up on a fresh VPS Acceptance ...
...through past days. I also want the raw JSON/CSV available for export so I can feed it to our internal BI dashboards later. Technical expectations • Android Studio / Kotlin (or Java if you strongly prefer) with the latest Google Maps SDK and fused-location provider. • Accurate, low-drain background location tracking that still complies with modern Android permissions. • Local database (Room or SQLite) for offline storage; sync hooks ready for a REST endpoint we’ll supply. • Source code in a private Git repo, plus a signed APK for testing. Acceptance criteria 1. Distance total matches Google Maps straight-line calculations within ±2 %. 2. Meeting Point arrival is detected within a 25 m radius. 3. App remains responsive after 8 h of...
...and generate simple reports or CSV exports without ever leaving the interface. A clean, intuitive UI is important because I expect non-technical staff to use it daily. Under the hood, I’m open to the stack you feel is most stable—C#/.NET (WinForms or WPF) or a lightweight Electron build are both fine as long as startup time is fast and the installer is straightforward. Local storage can sit in SQLite or a small embedded SQL Server database; just make sure the data file is easy for me to back up. I’ll provide the exact field list and sample data once we start, but anticipate roughly 15–20 columns, a few dropdowns, and one attachment field per record. All code must be well-commented, and I’d like a brief hand-off call or screen-share at the end so I ...
...Incident/Accidents management section Deliverables 1. React Native source (TypeScript preferred) structured for iOS and Android builds. 2. Clean, commented code for Face ID / fingerprint / password flows plus license-photo comparison. 3. Waze integration module with sample trip hand-off and callback handling. 4. Simple UI for pre-trip checklist and incident reporting stored locally (basic SQLite or on-device storage is fine). 5. Build & run instructions and one recorded demo showing the above flows. Acceptance criteria • Face ID/liveness check rejects mismatched faces in test images. • Waze opens with the exact destination and returns to the app when navigation ends. • All features compile and run on both iOS 15+ and recent Android 11+ devic...
...Incident/Accidents management section Deliverables 1. React Native source (TypeScript preferred) structured for iOS and Android builds. 2. Clean, commented code for Face ID / fingerprint / password flows plus license-photo comparison. 3. Waze integration module with sample trip hand-off and callback handling. 4. Simple UI for pre-trip checklist and incident reporting stored locally (basic SQLite or on-device storage is fine). 5. Build & run instructions and one recorded demo showing the above flows. Acceptance criteria • Face ID/liveness check rejects mismatched faces in test images. • Waze opens with the exact destination and returns to the app when navigation ends. • All features compile and run on both iOS 15+ and recent Android 11+ devic...
...dancer is based in. • Attach multiple photos to each profile (photos are the priority), with the option to add a video clip later. • Browse or instantly search by city; that is my main way of organising the list. • From any profile, tap a button to share it straight to WhatsApp or Instagram without exposing the rest of the database. • Keep everything offline in an on-device database (Room or SQLite is fine). A simple “Backup / Restore” to a single file in local storage or Google Drive is enough to protect the data when I switch phones. Acceptance check The job is done when the APK lets me: 1. Add at least one profile, attach three photos, and see it listed under its city. 2. Find that profile using the city search field. 3. Share i...
...ingin membangun aplikasi Android sederhana yang berfokus pada satu fungsi utama: sistem login pengguna yang aman dan lancar. Ruang lingkup: • Desain dan pengembangan front-end serta back-end dasar untuk proses registrasi, autentikasi, dan pemulihan kata sandi. • Antarmuka bersih dan intuitif agar pengguna baru dapat masuk tanpa hambatan. • Penyimpanan data pengguna terenkripsi (Firebase, SQLite, atau solusi setara—saya terbuka pada rekomendasi). Kriteria penerimaan: • APK siap instal dan kode sumber terstruktur. • Dokumentasi singkat cara build dan mengonfigurasi lingkungan. • Semua dependensi dan versi tercantum jelas di README. Jika Anda juga bisa menambahkan opsi seperti pembayaran online atau pemberitahuan push di masa depa...
...generar una factura en PDF y, si lo deseo, programar un recordatorio automático para la próxima cita (correo, SMS o cualquier integración sencilla que me propongas). También me interesa un pequeño panel estadístico con los tres datos que más consulto: • Número de sesiones por paciente • Ingresos mensuales • Frecuencia de visitas promedio Acepto la base de datos que te resulte más ágil (SQLite, Access, etc.) siempre que quede embebida y no requiera servidores externos. El diseño debe ser intuitivo: pocos clics, campos claros y posibilidad de buscar rápidamente por nombre, teléfono o fecha. Entrego contenido de ejemplo (clientes, logo y texto legal) en cuanto emp...
I need a Python-based trading program that plugs directly into the Zerodha Kite API and runs end-to-end on live Indian equity and F&O markets. The code must handle three pillars inside a singl...into clean, modular Python 3.x code, document every major function, and leave configuration values in a single YAML/JSON file for easy tuning. Acceptance criteria 1. Strategy runs in paper mode for one day without manual intervention and follows all risk constraints. 2. Switch to live mode with the same codebase—only the “mode” flag changes. 3. Order, trade, and P&L logs write to CSV and SQLite. 4. README covers setup, environment, and typical troubleshooting steps. Time is critical—please be ready to deliver an initial working version within days an...
... ↑ Expert Knowledge (System Prompt / Fine-tuned Model) Technical Requirements Language: Python (preferred) — open to Node.js for the automation layer if needed Key Libraries: OpenCV, Tesseract/EasyOCR, Playwright or pyautogui, OpenSpiel or PokerRL, SQLite or PostgreSQL for opponent tracking, Anthropic SDK / OpenAI SDK for LLM integration AI API: Must have experience integrating LLM APIs (Claude, GPT, etc.) into real-time decision systems — prompt engineering, structured output parsing, latency management, and caching strategies Deliverables: Fully functional bot that can autonomously play a free poker tournament from...
...analysis 4. Receive betting recommendations classified by risk/confidence 5. Track results in "Bankroll Management" (BetTracker) --- ### CURRENT TECH STACK: **Frontend:** - HTML5, CSS3, Vanilla JavaScript - Responsive design - i18n system - 4 languages: PT, EN, ES, FR - Subfolders for each language: `/en/`, `/es/`, `/fr/` **Backend:** - Python 3.10 (custom HTTP server with socketserver) - SQLite database - API integrations: OddAlerts (odds data), Grok/OpenAI (AI analysis) **Infrastructure:** - Ubuntu 22.04 VPS on GoDaddy - Nginx reverse proxy - SSL/HTTPS via Let's Encrypt (Certbot) - Domain: --- ### CURRENT ISSUES THAT NEED FIXING: #### 1. **Backend/API Issues:** - [ ] Python server sometimes crashes and needs manual restart - [ ] No automatic monitoring...
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...
Hello folks, I developed a desktop application a few weeks ago. It includes a SQLite database, allows users to search using queries, and can export results to a Word document. It’s a fairly simple search app. However, I now need to update the database and rebuild the application. I can do this myself, but the problem is that other team members don’t know how to update the database or rebuild the app. So I have two ideas: 1. Modify the application so users can drag and drop the database file each time. This way, they wouldn’t need to rebuild the app whenever the database is updated, but they would always need access to the database file. 2. Create an automated solution that updates the database and rebuilds the desktop application with a single click. I&rsquo...
...green/amber/red). Client approval workflow. Project Workflow: Employer dashboard—approve partner/worker, view supply chain compliance (status bubbles up: Subcontractor > Contractor > Client), issue worker badge. Audit/Consent: SHA-256 logs (simulating blockchain), simple approve/share. Tech Stack: React Native (mobile app + responsive web dashboard). Backend: Node.js/Express + mocks, SQLite DB. Auth: JWT. QR for badges/PQQ. Deliverables: Functional React Native prototype (app + web). GitHub repo (full source) + free hosted demo (Heroku/Netlify/Vercel). README w/ setup guide, API mocks list. Timeline & Milestones (AGILE, Daily Updates/Weekly Demos): (Week 1 End): Figma wires/prototype (ID upload, PQQ form, dashboard mock). (Week 2 End): Full build, mocks, ...
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)...camera monitors (manual check) and click an "Approved / Confirm Exit" button on the portal. The portal must log the exact date and time of the confirmation for auditing. Audit Log / Reporting: A simple table view for management to see all completed "Checkouts," showing the timestamp, driver, and trailer number. Technical Requirements Language: Python (Flask or Django) or Node.js preferred. Database: SQLite or MySQL (must be lightwe...
...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 accelerate development in specific areas....
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 missi...
...Weight Tracking Workout Time Tracking Diet Status Tracking Progress / Improvement Reports User authentication Data storage on server / cloud Basic Admin Panel Future feature expansion planned Required Skills Android App Development (Java or Kotlin or Flutter – Android only) REST API integration Backend communication (Firebase / PHP / Node.js – any) Database handling (Firebase / MySQL / SQLite) Bug fixing & performance optimization Basic UI/UX understanding Git / version control (preferred) Job Type Hourly Contract 20–30 hours per week (flexible) Long-term opportunity for the right developer Budget Hourly rate: Negotiable (based on experience) Preferred Location Bangladesh Pakistan India Preference Will Be Given To Developers with ...
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 r...
... • Billing & invoicing – once the second inspection passes, generate the delivery challan automatically, raise the GST-compliant tax invoice, and later update each invoice with receipt dates, partial payments and outstanding balances. Everything runs locally on Windows so performance is critical even when the network is down. A clean WPF or WinForms front-end connected to a lightweight SQL (SQLite or SQL Server Express) back-end would work well, but I’m open to your preferred Windows-friendly tech stack as long as the UI stays snappy and the database is easy to back up. Acceptance will be based on: 1. Installer (.exe or MSI) plus complete, well-commented source code. 2. Role-based log-in (storekeeper, technician, inspector, finance) with simple permis...
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...
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...
...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 persistence) · Frontend: Simple dashboard with TradingView charts · Broker API: DhanHQ (Indian broker) · Libraries: pandas for calculations System Architecture ``` Simple Personal Trading System: 1. Data Layer: Fetches prices from DhanHQ 2. Logic Layer: Applies my trading rules 3. Execution Layer: Places orders (optional paper...
...and handed over in an Android Studio project so we can maintain it internally. On delivery I will test: 1. Successful login for each role with only the screens authorized to them. 2. Real-time updates of fees paid appearing in both student and admin views. 3. Profit & loss report accuracy against a CSV I will supply. If you have relevant experience integrating Firebase Cloud Messaging, SQLite caching, or similar, let me know—that would be a plus, though not mandatory....
...the underlying data file reflects the same numbers. Deliverables 1. Fully commented Python code with a brief README explaining any third-party libraries. 2. A sample ledger template populated with dummy data so I can test before feeding live numbers. 3. Instructions for installing dependencies and running on Windows 10. Use whatever modern Python tooling you prefer—pandas, openpyxl, sqlite, or a lean custom parser—as long as setup stays simple. If the above flow works end-to-end, the job is done....
...Chart Logic * TradingView lightweight charts / equivalent * Use defaults values Support multiple timeframes: * 1 minute * 5 minutes * 10 minutes * 30 minutes 4. Data Storage & Retention (Temporary) * Store real-time WebSocket data for 1–2 months * Purpose: strategy validation & debugging * Implement: * Automatic rolling data window * Continuous cleanup of older data * Efficient storage (SQLite / Postgres / files — open to suggestion) 5. Real-Time Alerts (Critical Requirement) * Trigger instant Telegram alert based on the logic defined * Alert must fire immediately * Logic runs: * Every trading day * On AWS EC2 Windows instance * Alerts must be filtered strictly to IST market hours * No duplicate or delayed alerts 6. Interactive Charting * D...
...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 message typed offline should appear instantly in t...
.../ database data Unity loads experiment data dynamically from server No Unity scenes per experiment No hard-coded experiment logic This is a data-driven simulation platform, not a collection of Unity scenes. Technology Stack: Frontend (Simulation): Unity (WebGL build) C# JSON-driven runtime Prefab-based equipment system Backend / Admin Panel: PHP (Laravel preferred, plain PHP acceptable) MySQL / SQLite REST APIs to serve experiment JSON Assets: All 3D assets (.glb / prefabs) will be provided by me Freelancer will focus on logic, architecture, and tooling Unity Runtime Responsibilities: Load experiment JSON from backend Dynamically instantiate equipment prefabs Position equipment based on JSON Attach interaction controllers (drag, tilt, pour, rotate, heat) Maintain simulation state...
...paper mode toggles that rely on the same functions, ensuring what I back-test is what I deploy. • Position management: automatic stop-loss and take-profit placement as soon as an order is filled, plus trailing stop capability. • Resilience: graceful handling of rate-limits, connection drops and API errors; restart should pick up open positions correctly. • Clear, timestamped logging to CSV or SQLite for fills, PnL and key signals. • Simple config file for API keys, instrument whitelist, risk caps per trade and per session. Deliverables 1. Python 3.x source with inline comments and docstrings. 2. Quick-start README explaining environment setup, required packages (requests, pandas, numpy, ccxt or native DeltaExchange SDK, whichever you prefer) and e...
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 datab...
...attaching photos, notes and a timestamp. Deliverables 1. React Native source (TypeScript preferred) structured for iOS and Android builds. 2. Clean, commented code for Face ID / fingerprint / password flows plus license-photo comparison. 3. Waze integration module with sample trip hand-off and callback handling. 4. Simple UI for pre-trip checklist and incident reporting stored locally (basic SQLite or on-device storage is fine). 5. Build & run instructions and one recorded demo showing the above flows. Acceptance criteria • Face ID/liveness check rejects mismatched faces in test images. • Waze opens with the exact destination and returns to the app when navigation ends. • All features compile and run on both iOS 15+ and recent Android 11+ devi...
Budget: $1,800 USD (Fixed Price) Timeline: 7-10 days Tech Stack: Python 3.10+, Playwright (Async), SQLite, Ubuntu VPS Skills Required: Python, Playwright, Web Scraping, Async/Await, Proxies, SQLite ═══════════════════════════════════════════════════════ PROJECT DESCRIPTION ═══════════════════════════════════════════════════════ I need 4 production-ready, high-performance web scrapers for auto parts websites and auction history. The goal is to build a robust data pipeline that runs autonomously on an Ubuntu VPS using Bright Data residential proxies. WEBSITES TO SCRAPE: 1. (Wholesale parts - Login required) 2. (Wholesale parts - Login required) 3. (Auction history - Public) 4. (Retail catalog
...answers when evidence is found Displays citations (document name, excerpt, date, author) Shows confidence level and “as-of” timestamp Developing a simple web UI (FastAPI/Django + React or similar) Using open-source/local LLMs (Ollama, vLLM, etc.) Enforcing security and role-based access (basic level) Preferred Tech Stack (Flexible) Python LangChain or LlamaIndex FAISS or Qdrant PostgreSQL / SQLite FastAPI or Django Local LLMs (Mistral, Llama, etc.) React / simple frontend Deliverables Working chatbot web application Ingestion pipeline scripts Vector search + citation system Documentation for setup and deployment Sample queries and test cases Source code in GitHub repository Who Should Apply We are looking for someone who has: Built chatbot or RA...
...runs smoothly on both smartphones and tablets. Core modules include customer and vehicle records, job-card creation with live service tracking, billing and invoicing, and a notification layer. A simple customer login (email + password) must gate access to their own service history and invoices. The code should follow clean MVVM architecture, use Retrofit (or equivalent) for REST calls, Room or SQLite for local persistence, and Firebase for cloud messaging and analytics. I expect concise, well-documented Kotlin that is easy to scale and hand over. Please share links to Android apps you have shipped, highlight Kotlin projects that use MVVM, Room, and Firebase, and give me a realistic timeline plus a price breakdown (fixed or hourly—open to either). Delivery milestones wi...
I need a very small-scale “copy-pest” style build: a s...e-commerce, portfolio, or blog features are required—just a clean form, basic styling, and reliable logging. Core flow 1. Page loads or refreshes and displays a random text CAPTCHA (use any open-source library you prefer). 2. User enters the answer and clicks submit. 3. System checks the answer, then writes the challenge, response, result (pass/fail), and timestamp to a simple store—CSV, SQLite, or MySQL, whatever is fastest for you to wire up. 4. An admin-only view lets me download or clear the log. If you already have snippets or templates, feel free to copy-paste; speed and simplicity matter more than pixel-perfect design. Just package the final code, a quick README with setup steps, and I&...
...is an incremental upgrade focused on user management and auditing. Primary tasks • Introduce a distinct Admin role with the usual create/read/update/delete privileges over files and users while keeping existing anonymous or regular-user access intact. • Add a lightweight, searchable activity log that records uploads, downloads, deletions and permission changes with timestamps and usernames (SQLite or another simple store is fine, as long as it plugs cleanly into the Flask app). Acceptance The new routes, templates and database tables should integrate with the present codebase without breaking current endpoints. I should be able to: 1. Create an Admin account from a CLI script or a protected web form. 2. View a paginated activity log directly from the dashboa...
...notified 8th CPC fitment factors. • View, download, or print a neatly formatted report that shows month-wise differences, totals, and deductions. • Store every run in a lightweight database so I can pull it back later, edit inputs, and regenerate the report. I am comfortable with a JavaScript/Node.js stack; Express on the back end and a clean front-end (plain HTML/CSS or React—your call) will do. SQLite or a simple JSON datastore is enough; no heavy infrastructure. Deliverables: 1. Node.js project with clearly commented arrears-calculation module and official formulae hard-coded. 2. Responsive UI with forms, validation, and a printable/downloadable PDF report. 3. Local data persistence and a quick search/filter screen for past calculations. 4. Brief README e...
...into a clean, searchable database. Each record must be keyed in exactly as it appears on the scan, with fields correctly mapped so I can run queries later without manual fixes. Your job covers: • Extracting text accurately from every PDF scan (no OCR errors that shift names, dates, or figures). • Populating a structured database table I will provide—or, if you prefer, creating one in MySQL or SQLite and delivering the dump. • Spot-checking entries for consistency and flagging any illegible sections so I can clarify them quickly. I will supply the full set of PDF files and a field layout guide as soon as we start. Finished work is accepted once all pages are entered, totals match the originals, and no placeholder text remains. If you’ve handled lar...
Top Articole ale Comunității sqlite
Using PHP PDO to manage data in MySQL
Details about how to use the PHP PDO library for data manipulation