For my project, a web application, I need to store user data in a database. Obviously all users are stored together with their unique ID, but what about “items” users create within the application? After a user is logged in they can create “items” within the application, whatever an item may be. Each item has … Read more
I want to store a hashed password (using BCrypt) in a database. What would be a good type for this, and which would be the correct length? Are passwords hashed with BCrypt always of same length?
I have a requirement to store user uploaded files to the database (filesystem is not an option).
I need to store a very large number (tens of millions) of 512-bit SHA-2 hashes in a MySQL table. To save space, I’d like to store them in binary form, rather than a string a hex digits. I’m using an ORM (DBix::Class) so the specific details of the storage will be abstracted from the code, which can inflate them to any object or structure that I choose.
A database engine (or storage engine) is the underlying software component that a database management system (DBMS) uses to create, read, update and delete (CRUD) data from a database. Most database management systems include their own application programming interface (API) that allows the user to interact with their underlying engine without going through the user interface of the DBMS.
While searching trough SO, I’ve found two contradicting answers (and even a comment that stated that) but no definitive answer:
A while a go I had to developed a music site that allowed audio files to be uploaded to a site and then converted in to various formats using ffmpeg, people would then download the uploaded audio files after purchasing them and a tmp file would be created and placed at the download location and was only valid for each download instance and the tmp file would then get deleted.
I want to store
ip2logn($_SERVER['REMOTE_ADDR']) values in the db for some reason.
I am developing a mobile web application (for iPhone & Android) with a local database (using html5 webstorage) so my app is still usable when the user is offline. This is working perfectly, but I want to save the local data on a server. So I need to synchronize the local DB with a DB … Read more
According to the newest regulations and our law department each website our company owns/manages needs to have a page that lists all cookies and local storage items used on the site. I tried to find some examples on how the actual list should look like. I managed to find a table of cookies that contains all cookies used on site – it has 4 columns in total: cookie name, cookie type, its purpose and duration.