Hello, We are working on a project, where we have to take the user details and store it in a database. We are SQLite browser for creating tables and DroidDraw for UI. We are having couple of options to storing the data : 1. Saving the db file in the asset folder of the android project and entering the new records using AssetManager. 2. U...
hey guys Is it a good idea to store video files in a database as BLOB objects or store them on a physical disk. This is for a site similar to youtube where users can upload their video and view them Database would be Mysql Which option is better and why Thanks ...
hi there, i am using java sqlite (org.sqlite.JDBC) with this i am adding a new row of data to the table, one field is supposed to take up a big amount of base64 encoded data (like pdf) the type of this field is sql-TEXT. now, if i delete the row with "DELETE FROM table WHERE id='id'" the row gets deleted as expected, my sqlite browser c...
I would like to create a WPF application in C# that can show visually, in a user interface friendly way, the relationships between tables from a database chosen from the application user (MS SQL Server, MS Access, Oracle, MySQL, etc.) and allow the editing of the relationships. For example, in Microsoft Access 2007 it is possible to do...
With respect to Oracle Database 11g transparent data encryption (TDE) with HSM, I understand that the following command is used to set the master encryption key. However, why does a user_Id have to be specified when the PKCS#11 library for the corresponding HSM only requires a PIN? SQL> ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "use...
I have looked through the whole set of "Oracle Database 11g Release 2 (11.2) Documentation" searching for the details of the master encryption key used for transparent data encryption (TDE) with HSM. There was only a single insignificant line out of the whole set of documentation that says it makes use of AES. What surprised me was that...
I am currently in the process of coming up with a PKCS#11 library with minimal functions such that my legacy HSM is able to support the Oracle database 11g transparent data encryption (TDE). I do not want to come up with the complete PKCS#11 library with all the functions since all I need is to support Oracle database. In addition, codin...
I have asked how to DBSM and would like to proceed knowing more about MySQL. When I log into their website, I dont know which one to try. There are Community Server, Cluster, Workbench and Connector. Please guide. Note: I am working on excel database (which I found out on this website that it is not a good way to do it) with size o...
I keep getting this error: Invalid object name "CAccounts". and the code I have is: System.Threading.Thread thread = new System.Threading.Thread(() => { // Set ConnectionString. String sConSg = "CONNSTRING HERE"; using (SqlConnection connection = new SqlConnection(sConSg)) { try { c...
The query I am running is select accountid from general order by accountid ASC The result I get is accountid ------------ 1 1001 1002 10021 10026 1006 1007 Why is it not ordering correctly? It's a simple query and I am completely lost at how I can resolve this matter. ...
I am trying to create an application which collects a lot of notes from users. I want to implement full text search on the notes so that the user can get relevant notes from the whole array of notes. I am looking for a solution for this. Full-text-search(FTS) is actually supported by SQLite, but is it available for Android? Can anybody ...
Hi, is it possible to load jsf 2 page from database, not from xhtml file? Eg., the request comes for /faces/foo.xhtml, FacesServet intercepts request and VieHanlder creates view foo.xhtml by loading foo.xhtml from a DB, not from the server? Thanks ...
How do i on checkboxselected , show a toast that has data from database? Thank you. ...
Hi Guys, I am making an SQL Query that brings back a list of files and their paths. They have different file paths and different file names ofc. The file names are dates and time in the form of YearMonthDayHourMinuteSeconds. What I need to do is take the filepath that thas the latest date and time, strip off everything except the dat...
hi. im making an application that store multipe information like name description images for each entity. ( large number of entity). I have an issue in storing images in for this application. whats the best way to store them. database or document directory. and also im affraid that the images will increase the size of my application. wai...
I connect to an oracle database from an ASP-VBSCRIPT website and want to execute a stored procedure which accepts input parameters as well as returning some. The stored procedure is the following: p_std_currency.get_currency_details(input1,input2,input3,input4,output1,output2) Input 1-4 are the parameters (3rd is dat...
This is a hard one (I think), on a SQL Server 2008 R2 database. I have a NotificationTemplate with zero to many NotificationSmsTemplate child bjects, because our SMS limits messages to 160 characters, I need to send several SMS's in sequence to deliver the whole SMS communication. Per NotificationTemplate, each NotificationSmsTemplate ...
How do I stop psql (postgres?) from outputting 'useless' notices? e.g. psql:schema/auth.sql:20: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users" yes psql I know, now be a good tool and stop telling me that you're doing things I want you to do. IMO a program should be silent unless it has an...
I am trying to implement the following setup: I have 5 different Apps. All 5 are part of one project. I am trying to extract all the common elements these different apps have. Than I want to make those elements variables that I can than make the view.py paste into templates I create. So I have templates that have variables in it like...
I have a database where several tables have a column email for storing email address. Because this is for surveys, a lot of values will be identical, more likely identical over names, addresses, etc. Should I just have a master Emails table, and then an email_id column? That way I'm only storing email strings once, instead of multiple t...