Advise for non-programmer the website for database management

Question

1.00/5 (1 vote)

See more:

what we have: a database with 134 columns, and about 200,000 rows
what I want:
1. at the required time, from the computer upload to web site database in excel format. 2.Users should be able to edit, correct, fill-in, save at the same time.
3.Users should be able to unload the database in Excel format to PC.
Preferably, offer a free website. Or hosting this is called, in my opinion
Thanks in advance.

What I have tried:

I have not tried anything to solve this issue as I am not a programmer.

Posted 22-Feb-18 22:02pm

Умрбек Матрасулов

Updated 22-Feb-18 23:02pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2018-02-22T22:19:00

Solution 1

There isn't any "standard web site feature" that will let you do that - especially the last one! Most companies and sites try really hard to prevent users downloading their databases, not tries to expose them for download by users.

So I'm sorry, but you will have to either learn to code, or pay someone to do this for you. There are sites where you can get developers to "bid" for work like freelancer.com - but be aware: you get what you pay for. Pay peanuts, get monkeys.
And you will need to write yourself a good, solid, full specification of what you want so that you and the eventual developer have a fixed target to work for and to measure delivery against. A couple of lines of vague description is not going to help as it leaves far too much to interpretation, and that causes costs to increase.

BTW: generally speaking, avoid "free web hosting" - it tends to either have expensive tech support (that you will really need) or be very limited or unreliable. Find a reasonably priced host that supports your native language and life becomes a lot less fraught!

Posted 22-Feb-18 22:19pm

OriginalGriff

Comments

Умрбек Матрасулов 23-Feb-18 4:35am

The fact that I have enough to keep a database on the Internet, I know how to automate the creation of reports in Excel. But, in Excel, users cannot work at the same time.
And so, I need something, something multi-user. And so I want it to be online. Because someone let's say on a business trip, and from there let him do what is required. My firm is not big, and it makes no sense to hire programmers when I can import a database edited by my employees into Excel and generate reports using formulas.

what did you mean when you talked about the native language? if you mean hosting in my country that could allow me to solve my current issue, then I understand. For this advice thank you

phil.o 23-Feb-18 5:07am

His other advises make sense, too, not only the one about finding a host who can provide support in your native language.
Excel is not a database system, even if many think it could be used that way at first sight. Better have a central, unique, real database system holding the data (MySQL, MSSQL, PGSQL, SQLite, ...); then you can import the data in Excel and use its computing and reporting capabilities.
Thinking that Excel is a viable data storage solution in a multi-user environment will come back and bite you very quickly, trust me.

Умрбек Матрасулов 23-Feb-18 5:49am

Okay, I understand. I wanted to learn MYSQL. Installed it on a laptop, but the program did not run despite the fact that I also installed NetFramework with the required version.
I began to think that perhaps the program is run the computer must not be a client, and needs to be a server. Although, I do not understand very well this concept.
Q: What database can I study on a regular personal laptop?

OriginalGriff 23-Feb-18 6:07am

A multiuser database is going to be a server/client system: one server which holds the DB and handles all requests from a number of clients.

MySql and SQL Server are both server systems: you install the database engine on a particular computer (the server), add your database, and access it from one or more clients (which may be the same computer but don't have to be). Typically, you would have just one computer in the office running as a server - except when developing software, where you want a separate database entirely because you will make mistakes!

MySql will work, but Sql Server is also free (or has a free Express edition) which may fit you needs - both are often supported by web hosting services, but go with the one that your chosen service supports, not pick one and look for a host that supports it. (The cheaper hosts generally only offer MySql as "full installations" of SQL server are quite expensive).
Either will install and work on a laptop, but generally speaking you need:
1) A central "production" database installed on a server. (This would likely be on you website, and is either accessed remotely if your hosting service allows that - some don't for security reasons - or via an application on the website server which "serves up" the data to the clients.
2) One or more client applications which connect to the server DB. This is more likely to be what you want on your laptop - a server installation is quite large and resource hungry, and would probably need teh lappie powered on and connected to the network / internet 24 hours a day.

OriginalGriff 23-Feb-18 5:08am

"Hosting in your own country" - yes. It makes sense to have support in your native language, office hours that are the same as yours, that kind of thing.

But what you are asking for is not trivial, and has to be done right or you will have bigger problems later on. If you have a system working with Excel and it's not giving you problems you can't form business working practices to get round, then stick with it - this probably won't be a "quick solution" as you need to be pretty careful what you are doing, particularly online. Do you want your customers or competitors to have access to your data? Probably not, few companies do ... so you have to start thinking about data security as well as accessibility: the two go hand in hand.

You don't need to necessarily hire a programmer permanently, many work freelance and will take jobs from several clients over the course of a year. But a freelancer will want a much more detailed specification to work against or they will want a "per hour" contract (and will cost more per hour than an employee) instead of a "fixed price" for the whole job.

Умрбек Матрасулов 23-Feb-18 5:57am

thanks for your answers