data Starting SQL

Sander Van Dam · July 23, 2018

Hey guys,

Im looking for someone who could help me with a little project I'm willing to start:

At my job, we have a lot of data ( ex names; adresses; phone numbers, etc. )

but I want to make my own "data program" so we can access our info a lot quicker, ive learned a bot from @CodeAcadamy,

but I'm not at all a know it all. How do I even start? yeah I know some basic commands and such,

but how do you even start making your own "program"?

Some things I have to consider is:

Were often on the road so this program must be accessible offline and would like to have basic search bar:

Ex: I put a name of a street, I can see all the adresses ( house numbers ) on that street.

To make it a bit easier to understand, would love to make like an offline "Facebook" data base;

I could just search a name and it would give me the info that I inserted of him.

and have different columns, like when we last visited the owner, and etc.

If anyone could help me, put me on the right track, would really appreciate it!

Im really excited about it and willing to put time and effort on my "little project"

Thanks.

vorticalbox · July 23, 2018

50 minutes ago, Sander Van Dam said:

how do you even start making your own "program"?

Firstly what type of program are you planning to make? a web app? desktop?

51 minutes ago, Sander Van Dam said:

Were often on the road so this program must be accessible offline

To do this you would require the whole database be shipped with every program, with lots of data this just isn't going to happen. You could do some sort of download were people can save some data to work on while on the road then push the changes to database when the connection is back.

What you should do is write a product spec, outline everything you need the system to do then you can go about designing individual parts.

Sander Van Dam · July 23, 2018

ohh okay, hmm...

basically I need a program with information about our clients and their information. We dont actually do any changes per say, but its more of an search tool. Also need to have a login system, so not everyone can use the program. Yeah we go back at the office and we have an connection then, but most of the time the computer stays in the car,

Also, maybe I'm asking to much ( really dont know a lot about this kind of stuff ) but can other people, ( in the office ), if they have to do an update on a clients "profile" could we do that wireless? ( with internet connection of course )

I need that all the users can make changes to the informations ( update ) even when offline ( then when online it will update the rest ) ... so we could also see what other people did before ( specific dates, who went and where ) etc..

Do you think if I would take the time to detail everything, how I would like it to work and etc. That someone on this forum would be able to help me? yeah sure I can pay the person to help me .. ( its gonna take time, of course ) ( not a 20k budget,.. just saying xD)

a bit clearer?

Peskanova · July 23, 2018

1º You need to make a database

2º You can make a widows(android-ios) app or a web-app
3ºYou can force your program to load the database from the server everytime they need to change/add data, just add a flag "modifyed" everytime they change some data they need to update the database and they cant update if the database is modifying now (low data consuption for checking only)
4º I've done something similar on vb .net and its so easy just a menu with the common sql comands, If dont know anything about sql or .net (or any code) try visual studio(.net i'm using) + sql express -> easy to make that program and you have the tools to understand and make a good program

Something like this(I think c# is better to make to portable instead .net but same shit) :