I have a data model with a bitfield defined something like this: alter table MemberFlags add column title varchar(50) not null default ''; alter table MemberFlags add column value integer( 3) not null default 0; insert into MemberFlags (title, value) values ("Blacklisted", 1), ("Special Guest", 2), ("A...
I am using UUID as the primary key in one of the tables. What are the pros-cons of having this field as a varchar/varbinary/blob? DB: MYSQL. TIA ...
I want to scale an e-commerce portal based on LAMP. Recently we've seen huge traffic surge. What would be steps (please mention in order) in scaling it: Should I consider moving onto Amazon EC2 or similar? what could be potential problems in switching servers? Do we need to redesign database? I read, Facebook switched to Cassandra fro...
Hi all! I'm doing an admin page that can view the users that exist in the system. My idea is to show a list of the users and the details in one page. I heard that using listview is very tedious. Is there any other way that is easy? Maybe view in textview but I dont know how it works. I must put in a lot of textview on my xml? A simpl...
Oracle SQL Developer Version 2.1.1.64 Database created in MS SQL Server management studio 2008. computer name: server instance: sqlexpress DB name: equipment No security, or windows security I guess. what do I enter in the following sql developer fields: hostname, port, SID/service name. ...
Hello, I am migrating a Weblogic 9 application to JBoss 5.1, and bumped into the following problem: A session ejb manages CMP 2.1 entities. Those are inserted at the time of the call to MyEntityLocalHome.create() method. Since the database table has "not null" constraints, some of the fields, who are normally set after the call to the ...
Hi, I'm trying to learn more about database transactions, I found the ACID rule of thumb for writing transactions and thought of a few questions. The ACID rule of thumb: A transaction must be: Atomic - it is one unit of work and does not dependent on previous and following transactions. Consistent - data is either c...
I am making a desktop application in C#, VS 2010 on Windows XP SP2 Pro. If i run that application directly from published folder without running setup OR run it from debug folder OR simply debug the application, it does not give this error. But if i run setup from published folder and then run it from start menu, it gives this error. ...
Hi in my database I have a field which holds foreign keys. Sometimes the values are NULL or 0. I know the helper blank?. Is there something similar to enable if there is a number set in the field? Because blank doesn't work here. the code for the view is something like this <%= @b.author unless @b.author_id.blank? %> ...
AdoTable1.Filter:= 'Date = #'+FormatDateTime('dd/mm/yyyy', Tomorrow)+ ' #' ; Why is Date surrounded with number signs?? Is this Access -specific?? thanks in advance! ...
I've been reading about database security when it comes to websites. And it says an attacker could steal a database and then have as much time as he wants to get all the user's passwords. If an attacker stole the database, why would he need the passwords as the authentication is done in php? So he could just access all the user's informa...
My initial approach to this was to use a stored procedure in database of Application A, triggered on an insert to gather additional data and call a web-service, hosted by Application B to do the necessary mapping and persistence there. Application A and Application B may not be on the same machine. The initial requirement is to support a...
Hi all, I have a table, let's call it attachments. I have an attachment id and the attachment filedata. However, unfortunately, when the files are uploaded, the size of the file is never put into a filesize field.....so I have a bit of a predicament. Is there a way I could do a query to calculate the size of a. a files size in megabyt...
What are web-based databases? I have heart this term a couple times. Is it some special database structure or product line name? Please, give me two words or more for more details. ...
Hi everyone, I want to know if there is a way to convert an MSAccess DataBase to a SQL Server database without starting from the beginning. Thanks ...
I have a query of the form: select m.id from mytable m left outer join othertable o on o.m_id = m.id and o.col1 is not null and o.col2 is not null and o.col3 is not null where o.id is null The query returns a few hundred records, although the tables have millions of rows, and it takes forever to run (around an hour). When I check...
My guess is that it shouln't have because they use centuries also in dates From here, The DATE datatype stores the year (including the century), the month, the day, the hours, the minutes, and the seconds (after midnight). Did it face the problem? ...
how can i search for a particular string in mysql? I tried using contains- gives me error: SELECT r.name , r.network , r.namestring , i.name , r.rid , i.id , d.dtime , d.ifInOctets , d.description FROM router AS r INNER JOIN interface AS i ON r.rid = i.rid INNER JOIN 1278993600_1_60 AS d ON i.id =...
I've been reading lately about disconnected DataContexts but there's a few things I don't understand. There seems to be a scenario where you'd want to use a disconnected DataContext and then a scenario where you have to use one. Why might you want to use a disconnected DataContext? In a single machine scenario I don't think it violat...
For example, you have an IRepository interface. You also have a SqlRepository class, which implements the interface, backed by a SQL database. Let's say the constructor for that class takes a connection string. If your repository makes stored procedure calls and if those calls are internal to the repository, isn't that a hidden depend...