Hey guys, I have here a simple question for those expertise out there (but please explain well, I'm very new). I made a visual basic 2008 application that allows you to login from a database. I followed this video: http://www.youtube.com/watch?v=p0dcPiLYrck But the problem is that I have to keep debugging my app if I make a new user. ...
I face one problem, one column is i have taken as numeric(38,0) Data stored in this column is going out of range, means it is reach it's storage limitation. i have tried with also bigint , but facing same problem.i can not take it as varchar because i have to use in another calculation so at that time i must need to convert it from varc...
I reviewed different means for connecting to oracle db from Haskell. I found one, ODBC. Ideally, I wish to use an oracle client to connect. Do you know any other way? Thank you. ...
I want to allow users of my application to add sub-users and set privileges for what each sub-user is allowed to view or do. My ideas is to have a separate PRIVILEGES table, like this: +-----------------+--------+ |privilege | value | +-----------------+--------+ |create sub users | 1 | |edit own profile | 2 | |add ne...
What is the concept of Sharding from Database Design perspecitve ? ...
I'm trying to get my team to think about only asking the database to do things it can do really well. I believe that when they stop thinking of the DBMS as an omniscient, omnipotent being and start treating it as a useful--albeit dumb--tool, they can begin to approach optimization and database design with the right attitude. That got m...
I started with Turbo Pascal 3, went to TP5, Bought TP6 called Borland the next day and downgraded to TP5.5. Bought Delphi 3, and now have Delphi 5 Enterprise. I sort of lost interest in writing code about 4-5 years ago for two reasons; Spent all day writing ASP & SQL for someone else. PC Techniques magazine went away. I've got a few ...
With administrative permissions im mysql, how can I see all the open connections to a specific db in my server? ...
When working on a project with several other people it's common to have several people with differente areas, such as the database. My challenge is how to let several people edit the database model in a continuous integration environment. A developer has suggested writing a "versioning script" where each edit was entered into a .sql ...
I've 3 tables: Parts: Name: internal name, Active: bool Languages: list of languages (English, French, German, ....) PartsTranslations: RealName and Id's of the other 2 tables. I would like to get a list of Parts telling me the internal name, active status and how many translations are missing (total lang subtract translations made)...
Hey Guys, Im currently working on a site which will contain a products catalog. I am a little new to database design so I'm looking for advice on how best to do this. I am familiar with relational database design so I understand "many to many" or "one to many" etc (took a good db class in college). Here is an example of what an ite...
Hi. I've become accustom to mysql user permissions along the lines of GRANT ALL PRIVILEGES ON db_base.phonebook TO db_user @'%' IDENTIFIED BY 'db_passwd'; and other things that affect how a certain user interacts with mysql. I have a database that was created by a program I ran and it has its own permissions. I can't figure out how t...
I have an existing database(Postgresql). How can i create models from it? How can i pass column names for Rails? As if something like this: Person: Name :table_name_for_name_attribute Surname :table_name_for_surname_attribute PersonalCode :table_name_for_perconal_code_attribute Unfortunately, my database is not following Rails convent...
I am working on quite a large DB based project and I like the look of a few of the power tools. Looking through the related downloads, I found out about GDR R2, I cannot find out that much information about it - Not even sure what GDR stands for, but one thing that caught my eye - "this release incorporates many previously released Pow...
I wanted to know, what should i consider while deciding if i should create a new table or modify an existing table for a sql db. i use both mysql and sqlite. -Edit- I always thought if i can put a column into a table where it makes sense and can be used by every row then i would always modify it. However at work if its a different 'rele...
I was wondering how databases are managed in open source projects which are usually hosted in repositories like CVS or SVN. Placing codes in the SVN is very logical as it allows different team members to get updated pieces of code but how about databases? Are their schemas and contents (.sql files I assume) placed inside the SVN too? In...
I have many tables; each has a primary key which is an Identity column with a seed of 1. I have another program which converts data from a previous database (dBase) to sql. This programs needs Indentity = No. How can I change Identity and Identity Seed from my code? ...
Hi, I'm a bit puzzled here. I did a form containing a simple datagridview containing data from an MDB file. The connection was alltogether done by Visual Studios wizard so alot of stuff was created automatically. Then I databinded the textboxes to each column in the database and managed to update the database via my own command buttons s...
I'm looking for a tool that can read multiple SQL queries and aggregate the data dependencies an relationships. For example if I have 20 queries that start with "Select * from employees" I'd expect to see the employees table weighted at the top. I imagine there has to be some data warehousing tool or other product out there to analy...
Are there any open source or commercial tools available that allow for text fragment indexing of database contents and can be queried from Java? Background of the question is a large MySQL database table with several hundred thousand records, containing several VARCHAR columns. In these columns people would like to search for fragments ...