QA: is it ok to use notepad for DB?

Is It Ok To Use Notepad For DB?

im trying to create a mini library system that will handle approx. 30,000-50,000 records. i am planning to use notepad as my back end. why or why should i not use notepad? im using vb .net. thanks. please give me a reason for using notepad that will make my panel understand. im just a student and i need a good defense. THANKS A LOT.
im trying to create a mini library system that will handle approx. 30,000-50,000 records. i am planning to use notepad as my back end. why or why should i not use notepad? im using vb .net. thanks. please give me a reason for using notepad that will make my panel understand. im just a student and i need a good defense. THANKS A LOT.

PLEASE GIVE ME A DEFENSE WHY I USED NOTEPAD. PLS.

Of course not.. think of performance. Like what i said, VB.NET doesnot have a command to extract a specific line from a text file. it'll read through then only find the record you need. (PHP has a function to read a specific line from a text file).

This means if you got 50,000 lines in your text file, you must wait till vb.net reads through 50,000 lines then sort it out. it's really slow!

i understand that you are a student, i used to be a student too and i like to learn from expert's advice. i used to think and ask questions like you too so i feel you..

In your application, i believe you will need to use several 'tables' or in your case, several 'text files' for different data. (example: a text file for student names, another text file for student ids, a textfile for bookid etc)

the big problem you will be facing if you use notepad is how to 'join' these textfiles to achieve your desired results. like how to link student X name from textfile A to his student ID from textfile B.. In a database, it's easy to link/join several tables using query to achieve your desired results..

i suggest you read up on SQL.. there are beginner topics from W3schools which is really helpful and easy to understand. it'll help you alot. meanwhile, keep posting questions here and i will be more than happy to share my experience

all the best!

link:
http://www.w3schools.com

I think it will be hard for you to search for your records if you are using notepad and hard to manage the records. Notepad will be only acceptable if your records are really small. 30,000-50,000 is like a lot data so Think twice.

There is sure a reason why ppl create applications. They are there to make your life easier. :D

Notepad is acceptable, since it saves in plain text format. However, i suggest finding a tool specially for that, since they usually come with thingsa such as code check, color coding, etc. This could come in handy when doing large code made to handle 30-50k records.