Sqlitecông việc

Mô tả công việc 1. Lập trình viên Iphone/iOS: • Có kinh nghiệm làm việc với iOS: Objective-C, Cocoa, XCode, iOS SDK, CoreData, SQLite, Cocos2d, Cocos3d... • Có kinh nghiệm kết nối giữa client-server sử dụng: webservice, Restfull, socket định dạng JSON hoặc XML • Có kinh nghiệm tích hợp Social Networks va OpenID • Kinh nghiệm build và publish Apple store 2. Lập trình viên Android: • Có kiển thức chuyên sâu về JAVA Core • Có kiển thức chuyên sâu về Android: layout, resource, SQllite... • Có kinh nghiệm kết nối giữa client-server sử dụng: webservice, Restfull, socket định dạng JSON hoặc XML... • Có kinh n...

...Validate JSON * Shared secret authentication * Proper HTTP responses Forwarding * Forward payload unchanged to configurable SignalStack URL * Timeout handling * Do not crash if downstream unavailable Logging Append each event to CSV (Excel-safe escaping): Required fields: * timestamp_received (UTC) * symbol * quantity * action * strategy_code * position_id * bucket * raw_json * forward_status SQLite optional but welcome. dempotency (critical) Duplicate webhook deliveries must not be forwarded or logged twice (hash or ID-based dedup acceptable) Configuration Via `.env`: SIGNALSTACK_URL, API_KEY, PORT, FILE_PATH, TIMEOUT Deployment Docker preferred or simple Windows service Include setup instructions --- Out of Scope No UI, no analytics, no broker integration, no da...

I want my intraday index-option opening-range breakout strategy coded end-to-end in Python, wired directly to the Dhan API for both live data and order execut...better once a target is hit. I already hold a Dhan account and will handle API activation myself, so you can concentrate purely on clean, well-documented code. The script should: • Authenticate and stream tick data in real time. • Place, modify and exit orders per the rules above, including partial exits at each target. • Log every event—entries, exits, rejections—timestamped in a CSV or SQLite file. • Fail gracefully on network/API hiccups and resume smoothly. Please deliver a single Python file (extensible modules are fine), a quick-start README, and a short call or screen share...

...that data to the tablet for daily reports so I can track usage patterns and detect any unauthorised activity. Deliverables • Embedded firmware for the bike-side BLE module with secure pairing, local timer logic, shutdown routines, and activity logging • Android tablet app with a simple dashboard to select a bike, issue start/stop, display live status, download logs, and store them in CSV or SQLite for later analysis • Wiring diagram and BOM for integrating the BLE module, power relay, and hardware E-stop into the existing bike electronics • Test procedure that demonstrates safe-state behaviour on link loss, timer expiry, power failure, and emergency-stop activation • Source code, build instructions, and brief documentation so my technical staff...

...comparison and timestamps. • Design and connect central database (PostgreSQL + SQLite) to store unique company records. • Integrate proxy rotation and throttling (BrightData/Luminati or similar). • Implement data normalization using ftfy, unidecode, python-phonenumbers, regex, and pandas. • Crawl Impressum pages to auto-fill missing fields (phone, fax, website). • Automate daily/weekly export to Excel / CSV using openpyxl. • Add basic monitoring dashboard (Streamlit) showing live progress, proxy health, and logs. • Deliver well-structured, documented, production-ready code. ⸻ Required Skills • Expert in Python web scraping (Scrapy / aiohttp / Playwright / asyncio) • Strong knowledge of PostgreSQL / SQLite, schema desi...

...monitor activity even when terminals are closed. • Ongoing performance tracking that aggregates P&L by symbol and by account, exports to CSV and displays a quick dashboard in a lightweight web UI. The code should be clean, modular and well-commented so I can extend it later. I already have API keys for my broker; please wire the solution to REST as well as WebSocket endpoints for market data. SQLite is fine for local storage—use Pandas for data handling and Plotly/Dash (or a similarly lean framework) for visual summaries. Acceptance criteria: 1. Master-slave architecture proven with three dummy accounts in a sandbox. 2. Average replication delay below 300 ms on local network. 3. Dashboard shows real-time positions and end-of-day reports without manual r...

...promotional logo videos posted on: Instagram TikTok YouTube X (Twitter) The bot must: Track views automatically every 3 hours Calculate earnings based on configurable CPM Support multiple active campaigns at once Provide leaderboards and stats Export campaign reports to Excel Store USDT wallet addresses (manual payout only) Expected volume: 8,000–10,000 submissions per month Database: SQLite 2. Campaign System The bot must support multiple campaigns running at the same time (different brands). Campaign Fields Each campaign must include: Campaign Name Brand Name Start Date End Date Budget (USD) Minimum Views Required CPM per platform: Instagram CPM TikTok CPM YouTube CPM X CPM Status: Active Ended Paid Rejected 3. Submission System Slash Comm...

...Android berfokus pada manajemen tugas. Intinya, pengguna harus dapat: • Menambah, mengedit, dan menghapus tugas • Mengelompokkan tugas berdasarkan kategori atau prioritas • Menerima pengingat (push notification) untuk tenggat waktu • Melihat statistik penyelesaian tugas dalam tampilan ringkas Desain antarmuka cukup sederhana dan intuitif; Material Design sudah memadai. Backend boleh lokal (SQLite/Room) atau memakai solusi ringan berbasis cloud—silakan rekomendasikan pendekatan terbaik. Harap sertakan: • Rencana arsitektur singkat (struktur folder, pattern seperti MVVM jika digunakan) • Daftar dependensi utama (Jetpack, Retrofit, dsb.) • Estimasi waktu pengerjaan per fase (UI, logika inti, testing) • Contoh proyek serupa...

...final decision ======================================== 6. INCREMENTAL LEARNING ======================================== Provide script to: - Load new benign traffic - Fine-tune existing model for limited epochs - Save new version - Avoid full retraining ======================================== 7. ALERTING & LOGGING ======================================== - Log detected attacks to file or SQLite - Store: - Timestamp - IP - Attack type - Confidence - Action - Make threshold configurable via config file ======================================== 8. DEMO & TESTING ======================================== Provide demo script to simulate: - Normal traffic - SQL injection payloads - XSS payloads - Brute-force login attempts - DDoS flood simulation - Malware uploa...

...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