Best Practices in PHP
Guidelines and best practices for PHP Web applications
...settings, statistics kept in a database, themes, animations, and asynchronous behaviour (timer-based actions and notifications). While some of the timer-based actions and notifications employed in this application generally might annoy a user, they are included in the assignment for the purposes of learning how to implement these features. Specifications: Track the win/loss statistics in an SQLite database Keep track of the timestamp every game was played and the result of the game in a table. You may consider storing the integer value of seconds from epoch for the timestamp, e.g.: (() / 1000) The statistics can be viewed and reset via a new activity launched through the menu Implement a menu for the Action Bar with two entries when clicked, starts the
Welcome! I am looking for an experienced programmer to help me with various tasks related to Swift, SwiftUI, and SQLite. Backing me is an extensive background in programming, and my current preference is for the iOS and Android platforms. I require assistance that ranges from debugging existing code to developing new features, adding enhancement and integration support with SQLite databases and other related technology. My ultimate goal is for the successful completion of the projects at hand, and a polished product that I can be proud of. I am willing to assign relatively more complex tasks and I am hoping to find someone who can complete the tasks in a speedy, efficient, and cost-effective manner. In the past, I have worked with developers on the iOS platform and I am ver...
We have a html form (attached in the zip) that on submitting data will save that data in an sqlite database. Some of the fields in the html form need to be populated with data from another sqlite database. All fields to submit are text fields, but one of them involves uploading an image file. Technologies used: - PHP 8.1 (server) - Sqlite (database) - bootstrap (html form) Files provided by us: - → sqlite database that contains 3 tables: consoles, publishers, genres (used to populate form) - → sqlite database with one table: games (used as where the form data is saved) - → a bootstrap html form containing the fields that need to be submitted (These are already attached here, so have a look) Please read the attached for detailed inst...
I need 19 existing SQLite .db files converted and imported into microsoft SQL server. Each file contains rows of one table. There are a total of 8 million rows of data split into 19 files. A sql server database already exists and the files are all being imported into a new table in that database. I need this today today please. I will send you the files (around 20gb) and you would then connect with my pc (anydesk) after converting and import into my existing sql server db which is on my local pc.
I'm looking to use a SQLite database on my computer drive, but need help integrating it into a React framework. I have experience with databases like MySQL and PostgreSQL, however, SQLite is the one I'm currently looking to use for this project. Because of this, I'm looking for an experienced developer who has experience working with SQLite databases and React framework. The full scope of the project will be discussed in detail once I've connected with the right person. Thanks in advance for your interest and I look forward to a great working relationship!
Please Sign Up or Login to see details.
1. Overview 1.1 This GUI will be used by a team to process jobs on their local laptops. 1.2 The data is captured by an upstream system, and for the purpose of this project, an SQLite database is provided to simulate the upstream data. 1.3 After this Freelancer.com project has been successfully delivered, we will populate the stubs and link this GUI to the upstream data source. 2. Technology components 2.1 Python 3.11.2 (Windows) 2.2 wxPython and its dependencies (requires VS & C++ component to build the .whl; we can supply a pre-built Python wheel to save time) pip install -U --pre -f pip install -U --pre -f wxPython 2.3 A pip package might be necessary to report on memory usage per subprocess. 2.4 Please ask before importing other pip packages
It is a desktop programme that could be compared to the union of a spreadsheet and a graphical calculator that helps students with their data science projects. Using the DB Browser for SQLite or by creating unique Java code connectors that download data from the network, they manually load data into the internal SQLite database. Then, they write custom Java batch formulas that utilise the data in the internal SQLite database to provide new results. They then use 3D graphs to visualise all the data. You don't need to be an expert in every facet of data science; you only need to establish a long-lasting framework that is data-agnostic. (You will be contacted to apply for the position and given more specific information.
BeBanjo Code Test This is a pretty basic Rails application with a couple of models and a handful of controllers. It requires Ruby, Rails, and Sqlite. This simple app allows Users (employees at media companies) to manage their Schedulings (scheduled media content). Setting up the application Traditional way 1. Setup Ruby in your machine (see .ruby-version file) 2. Setup everything with bin/setup (see the script for details) 3. Run the test suite with rake 4. Start the app with rails server 5. Visit http://0.0.0.0:3000 (login as any user in tests/fixtures/) With Docker If you prefer, you can use Docker: 1. Build the required Docker container: docker compose up. This command will create the container, but also will install dependencies and will boot the local web server. If you ne...
I have an existing meditation App on the iOS App store. It needs updating, but the Xcode Project is returning a SQLite Error --- No such module 'SQLite' --- I have seen this error before and fixed it but as it's some time since the App was updated (2 years) the error cannot be fixed this time for whatever reason following the instructions I have. I have a couple of deliverables. 1. Fix and return the xCode Project running successfully in the simulator. 2. Provide step-by-step instructions on how to fix the error if it occurs again. Thanks Andy.
It is a desktop application which could be described as a 'marriage between a graphics calculator and a spreadsheet' to assist students of data science projects. They load data into the internal SQLite database manually with DB Browser for SQLite or by writing custom Java code connectors that download data from the network. Then they use the data inside the internal SQLite database to create new results by writing custom Java code batch formulas. Afterwards they visualize all the data with 3D plots. You just have to provide a sustainable data-agnostic framework for years to come and do not need to know about all the details of data science. ( You will be contacted to apply for the job and will be given more detailed information you are expected to render i...
Ionic App for tracking bicycle ride Collect location information from the device (GPS) when a ride starts and calculate speed, distance and Elevation and write these data to sqlite database installed on the device. The location service runs in the background even if the app is closed (or the process is killed) and starts automatically when the device is restarted. Stops only when the rider taps the stop button from the app ui. Ionic 6, SQLite, Android, iOS
Looking for a developer to help with a small task. Needs to be done quickly
I am looking for someone with experience in working with very large datasets in mobile applications. Our maps are approx 1gb in size when saved as a geopackage. We are building a mobile application that will...building a mobile application that will display these maps using OpenLayers and cordova. The application is built for the most part with most of the functions and elements working well. We are looking to make this application 100% capable of working offline. Right now it is reading from a GeoServer. We are looking for the best method for storing and recovering data. We are open to using NoSQL, SQLite or almost any other method that will allow quick data processing at the lowest package size. We are looking to talk with someone through freelancer and will pay you for ...
I need to build a simple CRUD android app that uses SQLITE as the database. I am looking for the simplest project ever as this will be used as a blueprint for some students.
My Flutter App crashing with SQLite Error. Need to fix asap on Remote. This is pretty small project. Kindly bid accordingly. Please dont waste time.
...the highest authority to view student information, teacher information, course information, modify and delete teachers and students, and add new students and teachers Basic information of students: student number, name, password, gender, contact number, department, major, class Basic information of teachers: job number, name, password, gender, professional title, contact number Database: using SQLite or MySQL Front end: Vue Student interface: 1. Course information 2. Attendance management (only one can be selected for check-in and leave) Teacher interface: 1. Student attendance (set the attendance time, the default student status is to be signed in. If the student goes to sign in (or ask for leave) within the specified time, the status will be changed to signed in (ask f...
Have to install pysqlcipher3 on windows machine and run from pysqlcipher3 import dbapi2 as sqlite (DATABASE_NAME) to verify the installation
Setup TradingView Strategy to send orders to Interactive Brokers via webhooks. use Python, Flask, Redis, SQLite and asyncio. release job working on desktop PC.
Need help make a sqlite browser code fot execute my budget is what you bid.
From one dql file to another sqlite browser make the code editable with .bat script my budget is what you bid.
The project is to help me shift my current system of financial equity research from Excel based working to python and take my data to sqlite within Python. Also, since i intend to keep excel for GUI for most of my working, the knowledge of xlwings library is seeked along with the usual Pandas / Numpy / Seaborn (or underlying matplotlib) libraries I am not looking for a one time project but more like a co-development project on a consistent basis so please apply ONLY and ONLY when you have atleast 6 months of foreseeable availability. I will be actively involved in each and every step. Am finding little time to code myself because of other engagements but would want to co-discuss and co-develop the project. I foresee around 20 hours of active engagement on weekly basis. Can incr...
Help solve problems that are encountered will working on an iOS application using Xcode 14.2+, Swift 5.X, SwiftUI, and SQLite This phase of the project is a migration of this application to SwiftUI/Swift 5.x. All the code/function that powers it currently exists, the job is to tie the SwiftUI to the functions and update the existing swift code when needed. --- Phase 1 (2 hours): Populate screens with data for the SQLite database
I need someone experienced with SQL or MySQL or SQlite to import two dataset formatted in csv. And connected them together. And after connecting them, the data should be updated automatically when updated in the csv files. I need this to be done as soon as possible + I want to be able to understand the steps you did. So I can be able to do it myself.
Update existing Proxy Python to refresh sqlite daily and make a new installer
i want to import data from SQLite to MS SQL Server here I want to import the identity column value to the same in SQL SERVER I Try Then It gives an error identity column not insert I using entity framework core in C#
I need a node js app that will run LOCALLY and need to have these functionalities: 1. Handle two types of files via file upload: XML and CSV - no need to store files 2. Parse data from files to an array of JSON objects - not all data from files will be stored. I need a part of it. 3. Store JSON data to SQLite DB 4. Select and remove JSON objects based on criteria via API calls from a WebApp
We have a project that uses a JSON file to read data from a device. Now we want to change it so that instead of loading from a file, we look up the JSON from a SQLite database, then pass that object straight to the read function. I know we could do it by removing the JSON entirely and using pure SQLite, but I notice that since SQLite 3.9 there are actual JSON functions and operators. It seems like we can do the whole thing in less steps to use these.
...interior design style for the user. The application will guide the user through a series of collages with different interior design styles and the user will choose their preferred images. The program will then analyze the selected images and determine the most appropriate interior design style based on the user's preferences. Requirements: Experience in web development with Python, Flask, and SQLite Knowledge of machine learning and image analysis Strong problem-solving skills and attention to detail Ability to work independently and communicate effectively with the team Responsibilities: Design and develop a web application that guides users through the interior design selection process Implement image analysis and machine learning algorithms to determine the user'...
Hi, I have very specific requirements. I need a very clear Django REST backend example that performs the main functionalities: 1- JWT Authentication to log in. 2- Use the group-level permissions on the CRUD tasks Here are the details: ----- First, the example for sure will use an SQLite database, the database must involve two tables [Books, and Categories]. The Books table has three fields (ID, Name, and CategoryID) and the Category table has two fields(ID, and Name). And as you might think there is a one-to-one relationship between the two tables. The database should be created as normal using 'makemigrations', and 'migrate' commands. Second, the project must use the main packages below (and, any other new packages must be worthy and trusted) 1- Django 2- djan...
Hello there , I need part time dedicated developer for my on going project . My app is based on mobile recharge , flight booking , hotel booking Should have following experties *payment gateway integration *Implemention of Java code in react native using bridge *Sqlite database *Using Animation in app *Dynamic UI control *Publishing of app in playstore and app store My current app is -
I have a single class which encapsulate websql calls. I need to convert it to use sqlite-wasm I need to have it done fast. no agencies. single freelancers who is available right now I'll close the project when its done.
Create an app duplication of wordscape with sqllite database where we can add the words to be use Android studio Java Sqlite
It is a desktop application which could be described as a 'marriage between a graphics calculator and a spreadsheet' to assist students of data science projects. They load data into the internal SQLite database manually with DB Browser for SQLite or by writing custom Java code connectors that download data from the network. Then they use the data inside the internal SQLite database to create new results by writing custom Java code batch formulas. Afterwards they visualize all the data with 3D plots. You just have to provide a sustainable data-agnostic framework for years to come and do not need to know about all the details of data science. (soft solution proposal, step-by-step as-we-go milestone payments)
Export firefox history on a MAC to csv/text or Excel I amUsing firefox v104.0.1 upgraded to v109.0.1 macOS Big Sur Version 11.3.1 upgraded to Monterey V 12.6.3 There used to be an extenstion in firefox to do this , but is no longer available I belive I know where the data is - mostly in Would I use The "SQLite Manager" extension brings SQLite database interaction to my firefox browser What do you suggest Is this possible to provide.
Hello guys. I need to set up a simple php code that will help me to see clicks on different buttons on my websites. This is a list of options I need: 1. I need the ability to see clicks on a specific button (we need something like an ID for each tracker) 2. Tracker will track data from different websites so I need to include this data as we...to see clicks on a specific button (we need something like an ID for each tracker) 2. Tracker will track data from different websites so I need to include this data as well 3. And I need some simple way to reset all tracker data and export in any format. I will give a good bonus to a candidate who will do it quickly and suggest the best solution UI doesn't important for now. Maybe we can use SQLite instead of old fashion way. thank y...
...создана высоконагруженная информационную платформа для решения аналитических и исследовательских задач в области создания продуктов и услуг на мировых финансовых рынках: торговля валютой, ценными бумагами, производными финансовыми инструментами. В команду ищем опытного ETL разработчика, готового сочетать задачи по ETL 50%, а также 10% ML и 40% DS. Стек: SQL+PL/SQL Greenplum, Teradata, MSSQL, MySQL, SQLite,… DWH+ETL работа с хранилищами данных Hadoop Hive, Impala, Spark, Oozie, … Python pandas, numpy, pyspark, … Machine Learning Что делать: Рефакторинг прототипов моделей машинного обучения от команды DataScience – адаптация кода к пайплайну поставки моделей в промышленную эксплуатацию с сохранением результатов и оценки моделей в хранилище Greenplum (MLO...
I have a set of sqlite database crypted with SqlCipher. I know the passwords and I need a simple console exe for Windows that: - accepts two parameters: the file name of the DB and the password - password could be plain text or raw data (0x....) - open the file and save a copy without password You can use any Free/Open Source library that you like; I need the C++ or C# source code for Visual Studio Community Edition, last release, and the executable, with any dll or anything to make it ready to use. If you find a similar Open Source project and you fork from it to solve my problem, that's right for me. Don't use any commercial library that require royalty, because I have to share the exe/dll with some of my customers.
Hotel management system with Java Swing and SQLite
...MAUI to create the necessary UI. Deliverables SAD - System Architect document, basic as builts Complete code that I can deploy locally on my VS windows emulator and run on it Deadline is bit touch need this by 04 - Feb -2022 by COB As the deadline is short, I will need 12 hourly updates ! Before bidding please keep in mind to provide all of the tech you will use !! Specially DB ( I prefer SQLITE) The project is mainly about UI so a clear fluid running UI is needed. I don't have time to waste do not bid if you can't start the work start away !! I will tell you how I will mark the work !! Payments will be in 2 milestones only as I don't want to pay half and wait for rest for rest of the life !!...
Hello all, I am looking for someone who has the skillset to create a python script capable of reading the proprietary file in Avanset VCE format. The files rely on SQLITE and encryption. I need to open old archives and transform them to PDF. I am attaching the file for example.
Update proxy project to save in log current db and create a fresh one every day, based on time of
I need an expert who is good at working at SQlite
combine multiple sqlite dbs into one sqlite db
We are a SAAS platform (Timesite Pro) and are looking for a developer to join our team. We have an established app running on both platforms that requires ongoing maintenance and improvements and two more apps that we wish to create. This role is ideally one that wil...established app running on both platforms that requires ongoing maintenance and improvements and two more apps that we wish to create. This role is ideally one that will foster a long term ongoing consulting relationship. Please do not respond if you represent a company or a software development group. You will have experience with the following technologies Swift SwiftUI Combine framework SQLite Unit Testing UI Testing (nice to have) Xcode Kotlin Kotlin Coroutines Jetpack Compose Unit testing UI testing (nice...
I have a website template from github. I need help connecting it to connect to a local sqlite or mongo server. The job may be as simple as creating a *. js connector for jason and giving me instructions so I can access the database locally. I have a working php installation and use a local iis server. The source has APIs to connect to mysql or mongo in the file, lines 30342 to 30400. The entire site is attached.
Looking for experienced .NET MAUI developer with knowledge of Bluetooth RFID scanner technology? We are looking for a skilled developer to create a program that can batch read data from a TSL Bluetooth RFID scanner and save it to a local SQLite database. The program should have the ability to connect to the scanner, read multiple tags at once, and accurately save the data to the SQLite database. It should also have a user-friendly interface for configuring the scanner settings and reviewing the saved batch History. The user much confirm "commit" batch at the end of each batch read. We require the project code as well as brief documentation. One of our staff will be available to test the integration with the
Hello We have a .NET MAUI Android Application with SQLite working well. We need to sync the data with an online MySQL database using PHP. The Android App works in offline mode with SQLite but just need to work in online mode with MySQL server too If you are good fit, please bid with 'Net MAUI' words Thanks
Guidelines and best practices for PHP Web applications
Details about how to use the PHP PDO library for data manipulation
Entendiendo al programador