Microsoft Open Database Connectivity (ODBC) specification was created with a view to making it easier for an application developer to write systems involving communication with different types of databases.
The objective was to make it possible to develop an application system that would work unchanged with a variety of different databases. Although it was originally designed by Microsoft, it is now supported by all major database vendors and is subject to international standardisation.
Here I am going to attempt to define the term ‘database’; but unfortunately, like many terms used in computer technology, there is considerable variation in interpretations placed on the word ‘database’.
A basic look would be something like ‘a collection of data’. Ha ha, yes that is rather basic I know and trust me thats not it. I have more to tell you so stay with me. 
Another look might be ‘a large centralised shared data repository’, but surely that definition would not include a database on a personal computer.
The Database Concept! What do I mean by this? Well, I certainly do not mean that further down this article your going to see a fantastic picture of a new innovative concept car. (That would be nice though!)
No, what I mean by The Database Concept is basically the reason why we have databases today and use them so much in everyday life. Before I begin, lets just take a short look at the common problems with files systems in general that became apparent for us to consider the use of a database.
I have been creating random salts for a while now and thought to myself why on earth am I doing this manually? So I put together a short snippet of php code to create these values for me. Better still I made it so it generates a random salt everytime I click my create option.
So what is it I have created you ask? Well, I am gonna tell you. I have coded an automatic script that selects at random a series of characters (including lowercase, uppercase, numbers and special characters) set to a certain string length which is also changed at random, then I apply md5 hash to this value for added security.
Ok, so you might have seen my previous article when I provided my fellow world coding community with a SQL table structure and content for all the countries. Well, I am back again but this time I have one for all the states of North America (including Canada).
If you want to see my other SQL Table for countries then you can view it by clicking MySQL Table – Listing all countries.
I had an interesting debate the other day regards how somebody running an intranet system could use IP Based Authentification instead of having to create a user login system. So eventually we came up with a very simple code that I would like to share with you all today.
What do I mean by IP Based? Instead of having a system that requires users to login, then the code issues the correct options based on the users account security settings, we can use the IP Address which they use to view the page.
You might have managers who use certain computers because they have a personal username and password on their computer to load it up. So untilise that computers already existing security and use the IP Address to view the pages and set access options.
Shaun is a man with a background in joinery, music, administration, management, web development and technologies. A devoted friend and father to his wonderful daughter, he is also a family man. He likes to create and produce things which has led him into a stronger, more passionate pursuit of development.
Loading ...
Where possible I do not use cookies unless you have given me consent to do so.
As a valued visitor to my website, I am committed to maintaining your privacy and being clear & transparent on how I use cookies and any personal data you submit to me.
I use cookies to recognise website visitors and to store the way visitors use this site. This allows me to analyse website activity, so I can optimise the user experience and make sure I offer the best content for visitors.
I use cookies in order to give me information on the number of visitors to different parts of my website and thus to monitor which areas are most useful.
I do not collect personal information about my visitors unless you have submitted those details via one of my forms.
To find out more about my Privacy and Cookie Policy you can visit the following page:
Shaun Ellerton Feed