Server setup and data import from SQL database
Technical assignment: Server setup and data import from SQLite database
Project goal:
1. Set up the server (preferably CentOS).
2. Configure access to the server via SSH.
3. Import data from the SQLite database of self-service terminals into the server database.
Requirements:
1. Server:
Operating system: CentOS or another at the discretion of the performer.
Set up SSH access and security (firewall, SSL).
2. Database:
Source database: SQLite (file terminals.db).
Server database: PostgreSQL or MySQL (by agreement).
3. Data for import:
Extract revenue amounts with breakdown:
Cash (Banknotes, Coins).
Cashless payment.
4. Automation:
Develop a script for regular data updates (via cron or similar).
Provide instructions for working with the server and the script.
Timeline: To be discussed
Budget: To be discussed
Expected results:
1. A working server with a configured database.
2. Correctly imported data from SQLite with separation by types of revenue.
3. Automated data update process.
-
2 days50 USD2 days50 USD
Hello!
I will be happy to work on your project.
I will work until full approval.
Message me privately, and we will discuss the details.
The cost of services is not a dogma, but a reason for discussion. -
25 days400 USD
316 6 0 25 days400 USDI know how to configure servers, I am an experienced Linux user. I have experience in transferring data from sqlite to postgres for a Telegram bot.
-
7 days400 USD
11606 44 0 7 days400 USDI have experience in server configuration, working with SQLite, PostgreSQL, and MySQL databases, as well as creating scripts for process automation. I am ready to complete the task, ensuring server security, correct data import, and setting up regular updates. I would be happy to discuss the details!
-
4 days399 USD
2130 199 1 4 4 days399 USDContact me - I will do my best.
20+ years of administration experience.
Examples of clients for whom I have configured and support servers can be viewed on my website and in my portfolio on this exchange.
If desired, work under a contract with payment to a bank account is possible (I am a private entrepreneur, group 3).
30% of the money earned at this rate will be donated to support the Armed Forces of Ukraine.
-
2 days50 USD
172 2 days50 USDGood day
I am an experienced programmer with extensive knowledge of Linux systems, including CentOS
I am ready to complete your task. Install the OS, configure security, and import data into the database
Let's discuss the task over the phone or in a messenger.
The estimated cost is 50 USD, I will provide the exact cost after the discussion
Sincerely, Vitaly
-
5 days200 USD
284 1 0 5 days200 USDHello!
I have extensive experience working with databases and Linux administration, over 3 years of experience as a Backend developer, and a dozen commercial projects of varying complexity. I can confidently say that your task will be completed in the shortest possible time and with adequate security (ssh only with keys, firewall, ssl (if needed), and a fake ssh port for even greater security).
Regarding the task, it will be necessary to consider the technical limitations of the terminals.
I have some questions right away.
Are the terminals Linux? (if Windows - it can also be done, but it's more complicated)
Is there a possibility to run commands and create cron jobs there?
Is there a stable network connection on the terminal?
… The price and deadlines are preliminary; I was guided by the minimum complexity of the task.
-
10 days400 USD
3638 7 0 10 days400 USDHello!
I am ready to complete this project, having experience in server configuration, working with databases (PostgreSQL, MySQL), and process automation.
I will ensure the correct import of data from SQLite according to your requirements, configure server security, and develop a script for regular data updates.
I guarantee high-quality work within the established deadlines and will provide documentation for further operation. I would be happy to discuss the details and get started.
Sincerely,
Rostislav
-
7 days440 USD
418 3 0 7 days440 USDGood evening.
I can implement it.
_____________________________
Current freelance projects in the category Databases & SQL
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 23 hours 49 minutes back ∙ 9 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 1 day 10 hours back ∙ 4 proposals |
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 1 day 23 hours back ∙ 39 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 4 days 17 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
602 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 6 days 21 hours back ∙ 58 proposals |
Бишкек