Database Question
Quote from impactband4u on March 1, 2020, 6:26 amHi guys, for years that I've worked with Neobook > VisualNeo I never really learn how to work with creating and working with database. So i thought i give it a try, but first some questions.
- Is it really necessary to have a database in your pub? What is the main reason for database?
- Can i store anything for example (text files(.txt) Music Files (.wav .mp3 etc) in a database or not? It's more that i want to store files in the database and use it when i need it in my pub. Let's say i want to play a .mp3 file stored in my database etc.
- Can database serve as a safe or lock so people cannot extract files from database?
Where can i learn more about the Field Type in database and their meanings?
Thanks in advance
Hi guys, for years that I've worked with Neobook > VisualNeo I never really learn how to work with creating and working with database. So i thought i give it a try, but first some questions.
- Is it really necessary to have a database in your pub? What is the main reason for database?
- Can i store anything for example (text files(.txt) Music Files (.wav .mp3 etc) in a database or not? It's more that i want to store files in the database and use it when i need it in my pub. Let's say i want to play a .mp3 file stored in my database etc.
- Can database serve as a safe or lock so people cannot extract files from database?
Where can i learn more about the Field Type in database and their meanings?
Thanks in advance
Quote from mazzu001 on March 1, 2020, 7:22 amHi Impactband4u,
As far as "is it necessary?", That really depends on what you want to accomplish. The idea behind a database is to store data that can be easily sorted and queried. This is incredibly useful when you have a larger store of data. I have an app with over 3000 sound files in a database. I use 2 tables one for the details like Song, Artist, description, file size, audio length etc, and I use another table with the actual files (this requires some knowledge about table relationships but more on that after the basics i say) in a blob field or Binary Large Object. A binary large object can be any type of file. You just cant search the data contained in a BLOB field. For instance if you have a text file with the word "darkest" in the text file. But the file is named 12311.txt. If you insert that text file into the blob you will not be able to find the word "darkest" in it if you perform an SQL search.
The whole idea behind the invent of the database was, in some sense, to be a safe and secure place to store data. That's why, for instance, you must have a username and password to access a database on an MSSQL server or MySQL server and so on. So yes, it does in a way act as a "safe" however you must be careful on storing your user id and password in your applications code. This can be deciphered using packet sniffers and such. I don't really know about that part too much as I have never had an interest in hacking and stealing from people. There is a lot of wonderful resources readily available if you want to learn about SQL. www.w3schools.com is an excellent learning source. And there are people on this forum who know a great more than I do about it who are very helpful.
Hi Impactband4u,
As far as "is it necessary?", That really depends on what you want to accomplish. The idea behind a database is to store data that can be easily sorted and queried. This is incredibly useful when you have a larger store of data. I have an app with over 3000 sound files in a database. I use 2 tables one for the details like Song, Artist, description, file size, audio length etc, and I use another table with the actual files (this requires some knowledge about table relationships but more on that after the basics i say) in a blob field or Binary Large Object. A binary large object can be any type of file. You just cant search the data contained in a BLOB field. For instance if you have a text file with the word "darkest" in the text file. But the file is named 12311.txt. If you insert that text file into the blob you will not be able to find the word "darkest" in it if you perform an SQL search.
The whole idea behind the invent of the database was, in some sense, to be a safe and secure place to store data. That's why, for instance, you must have a username and password to access a database on an MSSQL server or MySQL server and so on. So yes, it does in a way act as a "safe" however you must be careful on storing your user id and password in your applications code. This can be deciphered using packet sniffers and such. I don't really know about that part too much as I have never had an interest in hacking and stealing from people. There is a lot of wonderful resources readily available if you want to learn about SQL. http://www.w3schools.com is an excellent learning source. And there are people on this forum who know a great more than I do about it who are very helpful.