Stack Overflow
Stack Overflow

Questions tagged [database-programming]

23 questions
6
votes
3 answers

What is the difference between a DataSet and a DataTable in .NET?

What is the difference between a DataSet and a DataTable in .NET?
paramasivam
  • 113
  • 2
  • 7
3
votes
1 answer

Getting right row while using inheritance of tables in PostgreSQL

I'm recently trying to drop Doctrine due to performance and problems with abstraction and move to database driven logic. I'm using mostly PostgreSQL. Doctrine One thing that I liked about Doctrine was inheritance, which I used for multiple…
Edke
  • 161
  • 1
  • 1
  • 6
3
votes
3 answers

Is it possible to Update an SQL Server Database and an Informix Database at the same time?

I was wondering if it is possible to add/update/delete an SQL Server database table, as well as an Informix database table at the same time. Both databases will have the same table (data and all), so the query would only change just based on which…
leety
  • 177
  • 5
2
votes
1 answer

Insert a single line of data into multiple rows of table

Synopsis: How to write the SQL code to insert one record from a flat-file into separate records to be inserted into a SQL Server table. Specifics: I have a table to record lease payments. For each rental agreement the due date is always the first…
Greg
  • 87
  • 8
2
votes
1 answer

Why is programming interface to database called driver?

When writing an application which updates or queries a database, we use something called a database driver (e.g. a JDBC driver). I wonder why it is called a driver instead of a library? Is libpq a driver too?
user3284469
2
votes
3 answers

getting data from memory instead of table

I have a parameter table with 10 rows. Called parameter_table. In my PL/SQL procedure, I do loop in 2 million records. And each time querying this parameter table too. I want to load this parameter table in to the memory and decrease the I/O…
Mehmet
  • 2,256
  • 9
  • 33
  • 47
1
vote
1 answer

Is Schemaspy secure for using with sensitive data?

I'm currently looking at metadata solutions for Microsoft SQL Server 2016. I'm interested in using Schemaspy. I think it looks like a great free way to document metadata, but I'm worried that it may not be secure for use in a company with sensitive…
Tom
  • 95
  • 5
1
vote
3 answers

SQL - Most performant manner to conditionally exlude a join? (if it's even possible)

If I have the following table structure... Table 1: BlogPost PostId | Name | Text Table 2: Tags TagId | Tag Table 3: BlogPostTag PostId | TagId And the following stored procedure... CREATE PROCEDURE SearchBlogPosts @tagstring…
matt_dev
  • 5,176
  • 5
  • 33
  • 44
1
vote
1 answer

Trying to connect to a Access database table in order to retrieve data, but encounter difficulties

First time doing database programming, so I just made a database in Access to try to do something with it. The database I created called "TestDatabase" on my desktop, and the table I created inside this database called "TestTable". And here is my…
Leon Ma
  • 303
  • 4
  • 13
1
vote
1 answer

How do you determine functional dependencies and a primary key?

In my Oracle Database Programming course, the first part of our final lab assessment requires that we: Identify the Primary Key of the table as it is currently shown Find all functional dependencies of the table which we are given to work…
Ephexx
  • 311
  • 4
  • 14
1
vote
1 answer

Have mysql re-allocate ids in a continuous range

I have an existing database in mysql. One of my tables has discontinuous ids. I would like to modify the ids of the table so that they go from 1 to num-of-rows. This particular tables does not happen to have incoming references, so the ids can be…
flybywire
  • 261,858
  • 191
  • 397
  • 503
1
vote
2 answers

Code Reuse Verses Database Access Duration

The Problem I have some code which I've coded in such a way to enable high maintainability and code re-usability. I am concerned about a particular piece of code and I would like a professional opinion on if this code will crumble under high…
Aelphaeis
  • 2,593
  • 3
  • 24
  • 42
1
vote
3 answers

visual basic 6 access 2007 database programming cascading combo boxes

I have a table named: schoolInfo in access 2007 and it has two fields (schName and mjrName). Now I'm trying to design a combo in Visual Basic 6 (cboMajors) which is related to the other combo (cboSchool). As a matter of fact I want to have to…
user2035282
  • 11
  • 3
1
vote
2 answers

SQLite and Cloud applications

i was wondering if there is a way to enable cloud features for a SQLite database application. Should i save the whole database to the cloud each time ? For example when i quit the application is it required to save the whole database to the…
alexandertr
  • 943
  • 1
  • 9
  • 18
0
votes
4 answers

Programming a scalable database

I want to ask you what programming language I should use to develop a horizontally scalable database. I don't care too much about performance. Currently, I only know PHP and Python, but I wonder if Python is good for scalability. Or is this even…
user1301036
1
2