LerN

When working with company's

16 posts in this topic

#1 ·  Posted (edited)

Hi, I just wanted to ask when you're working with a company or something like that do you load the data from INI files or from some servers what's the better and sefty way ?

Edited by LerN

Share this post


Link to post
Share on other sites



#2 ·  Posted

Not sure what you mean, exactly. If your script is time-sensitive, is there a reason the local system time where the script runs is not sufficient?


√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

I didn't get what u mean Jlogan

What I meant is when programmers loads data do they uses INI files or servers ?

Edited by LerN

Share this post


Link to post
Share on other sites

#4 ·  Posted

And I am saying, it depends on what you are doing. If you're writing a script that needs to just pull date and time, pull it from the local system. If you need something that pulls across time zones, use GMT. You have to be more specific, as there is no single answer for all circumstances.


√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites

#5 ·  Posted

Sorry I wrote data wrong I mean data not date 

Share this post


Link to post
Share on other sites

#6 ·  Posted

@LerN,

Not sure if I get it correctly of what you meant. Here's what I though, I'm currently in a company right now that has storing, loading, extracting data and we usually load it from the server, we are not loading it from INI file. There are cases that loading it in INI file might be risky from both parties and some might have corrupted it in their local system and can cause big issue.:sweating:

Just a heads up, every data that you load must be secured by adding some code of restriction/admin... etc...

 

KS15

Share this post


Link to post
Share on other sites

#7 ·  Posted

lol data != date. That surely changes things.


√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites

#8 ·  Posted (edited)

3 hours ago, KickStarter15 said:

@LerN,

Not sure if I get it correctly of what you meant. Here's what I though, I'm currently in a company right now that has storing, loading, extracting data and we usually load it from the server, we are not loading it from INI file. There are cases that loading it in INI file might be risky from both parties and some might have corrupted it in their local system and can cause big issue.:sweating:

Just a heads up, every data that you load must be secured by adding some code of restriction/admin... etc...

 

KS15

Can u give me some information about the servers, can i use it to load big data?

Edited by LerN

Share this post


Link to post
Share on other sites

#9 ·  Posted (edited)

I find I have a few minutes... perhaps this example of how a program might use stored information will help you:

Consider a company that makes cars. A purchaser, called Fred wants to be able to examine how many parts are required to make various systems for a car and asks a developer to write a program to help him.

Version 1
The program stores all the information about the parts and which system they belong to in a csv file on Fred's desktop. Each time Fred wants information on a system he types its name.

Version 2
Fred is pretty happy with this, but is getting bored of typing in the name of the powertrain system everytime he starts the program (because most of the time he is looking at powertrain components). The developer then adds a default system to open when the program is run. He stores this information in a local .ini file so that Fred can change his initial system if his work demands change.

Version 3
Fred loves this and gives a copy to his colleague Bob. Bob loves it and gives a copy to his colleague Jim. Everyone still keeps their local .ini file because they all have different requirements for a default setting.

Then engineering tells Fred that some of the parts have changed... and Fred realises there are uncontrolled and unmaintained copies of his data everywhere. Fred is sad and tells the developer what has happened. The developer suggests they store all of their data on a centralised file server, then there is only one file to maintain. A quick code change and a file copy and all is well. Everyone is now using one file that Fred owns and maintains on a remote server. 

Version 4
The developer is sacked and replaced by a developer who explains this should all have been done using an SQL database instead. The local .ini files can be replaced by user accounts and preferences incorporated into the database.

Finally the database corrupts and everyone is sacked because there was no backup strategy.

Whether you use a centralised server depends on the program and the users. How much data is stored is a function of the program and the users, this needs to be planned for. There are many issues associated with multiple access requests to served data, but I think that is a discussion for another day. The summary is, use an ini file to store local configuration data, everything else depends on requirements.

You can easily experiment with "large" data sources by creating a local SQLite database and filling it with random data. Understand local problems before you start to bring networks and multiple users into it. Check the help manual on _SQLite_Startup and follow that for a bit. SQLite is not a true server, but it will be an easy way to get a feel for one.

Edited by SlackerAl

Share this post


Link to post
Share on other sites

#10 ·  Posted

Best to work from a mirror db. Its safer. Never on the exact database.
This all depends on how you actually setup the backup structure of your database. 

Database and File Servers are the same when it comes to backing up. Periodically back up and access the data/files from a mirror.


Kind Regards
Skeletor

"I need coffee to turn me back to a normal human"

Share this post


Link to post
Share on other sites

#11 ·  Posted

So SQL is the best way ?

Share this post


Link to post
Share on other sites

#12 ·  Posted

LerN,

Define your project some more.  There is no "one size fits all" answer.

kylomas


Forum Rules         Procedure for posting code

"I like pigs.  Dogs look up to us.  Cats look down on us.  Pigs treat us as equals."

- Sir Winston Churchill

Share this post


Link to post
Share on other sites

#13 ·  Posted (edited)

Look bro i am not actually doing projects in autoIt but somehow i wanted to ask some questions about what developers do when they get a job or something like that 
What i meant is an company asked this developer to do an project for them and this company wants in list view names , age , code , telephone , notes and address etc 
and there's more that 8000 person will be showed in this list view so how do they load the names and age , code etc 
From ini files ? "Not Safety if something bad destroyed the hard" 
or from SQL server ?

Edited by LerN

Share this post


Link to post
Share on other sites

#14 ·  Posted (edited)

dont bro people here, lest you find out you are talking to a woman.  It is very much you who is asking an incomplete question.

If you have name/age/defining chacteristic (PII) stored in an ini, chances are you are not any kind of company that is audited or regulated, and if this was prod they would most likely not have SLAs or data handling controls in place.

At the very least you sit that data in a database optimized as a KV store like mongo, bro.

Edited by iamtheky
my awful ass grammar

,-. .--. ________ .-. .-. ,---. ,-. .-. .-. .-.
|(| / /\ \ |\ /| |__ __||| | | || .-' | |/ / \ \_/ )/
(_) / /__\ \ |(\ / | )| | | `-' | | `-. | | / __ \ (_)
| | | __ | (_)\/ | (_) | | .-. | | .-' | | \ |__| ) (
| | | | |)| | \ / | | | | | |)| | `--. | |) \ | |
`-' |_| (_) | |\/| | `-' /( (_)/( __.' |((_)-' /(_|
'-' '-' (__) (__) (_) (__)

Share this post


Link to post
Share on other sites

#15 ·  Posted

Any company would store all records of information in a database. The most common would be MS SQL. It does a far better job than any other database program.
So yeah, SQL would be the only option.


Kind Regards
Skeletor

"I need coffee to turn me back to a normal human"

Share this post


Link to post
Share on other sites

#16 ·  Posted

Another thing is if the data would need to be accessed without having to use the database or creating a read only user for example SSMS, then they would use IIS services and a web interface to access this information. 
Other than that, if you need to also insert the information, you can also use the web interface to do so. Just think about how you log into facebook, its the back end that does all the work... 


Kind Regards
Skeletor

"I need coffee to turn me back to a normal human"

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now