Database Questions

I know that a sql server full text index can not index more than one table. but, i have relationships in tables that i would like to implement

I have read that using database keys in a url is a bad thing to do. for instance, my table has 3 fields: id:int,

Here we go again, the old argument still arises... would we better have a business key as a primary key, or would we rather have a

I've worked on a number of database systems in the past where moving entries between databases would have been made a lot easier if all the

There are several types of objects in a system, and each has it's own table in the database. a user should be able to comment on any of them. how

I have the following tables in my database that have a many-to-many relationship, which is expressed by a connecting table that has foreign keys

As far as i know, foreign keys (fk) are used to aid the programmer to manipulate data in the correct way. suppose a programmer is actually doing

Ideally something that will work with oracle, ms sql server, mysql and posgress.

I wish to implement a program to monitor the gps positions of multiple aircraft. i will recieve updated positions every minute and wish to keep a

I have an interbase db. how can i convert it to sql server?

We have 18 databases that should have identical schemas, but don't. in certain scenarios, a table was added to one, but not the rest. or,

Do you guys keep track of stored procedures and database schema in your source control system of choice? when you make a change (add a

Okay, i've seen but haven't programmed in c# before. you can assume i'm competent in c++, and advanced in c (for what good that'll do me). i

I'm using php's pdo layer for data access in a project, and i've been reading up on it and seeing that it has good innate support for persistent

Hi all, we have a .net 2.0 application which has a mysql backend. we want to be able to deploy mysql and the db when we install the

I have a fairly small mysql database (a textpattern install) on a server that i do not have ssh access to (i have ftp access only). i need to

I'm currently looking at the python framework django for future db-based web apps as well as for a port of some apps currently written in php. one

I want to let users specify a date that may or may not include a day and month (but will have at least the year.) the problem is when it is stored

Is it possible for me to do something like this with a mongodb query (i'm using mongoosejs as well). in lodash, i can do

I fetch data and display in a tableview, the problem is the data is not executing in the correct order. i have tried:

This is the database below. i need to take the 'caption' child which is a timestamp and convert it into date format in xcode.

A lot of contact management programs do this - you type in a name (e.g., "john w. smith") and it automatically breaks it up internally

I am making an app where i can upload images to firebase then retrieve them and view them in a viewpager. the images have a name and an url. in

I'm a fairly experienced firebase user and i'm recently working on a gaming project with unity 2019. does the unity firebase

Hello i would like to know how to read data for the current user logged in and how to retrieve the data. the first code up to updatename function

I need to change the child value without create a new child using swift code and firebase database when i clicked on a button i tried to

I have this structure:

I have downloaded the zip of firebase real-time database node.js sample and navigate to the database section

Where i can download sample database which can be used for data warehouse creation? it should't be sample from microsoft (northwind etc.).

Does anybody know of any sample databases i could download, preferably in csv or some similar easy to import format so that i could get more

How do i write the results from a mysql query to file? i just need something quick. output can be csv, xml, html, etc.

The same error keeps coming up. i'm guessing they changed how it works now but since i'm a noob, i really need help fixing it.

I have a firebase realtime database set up with a bunch of basic rules revolving around basic user authentication: { "rules": {

I am trying to call data from firebase that changes the image view to be that of what is stored in the database. when i call my code, i see

I am trying to iterate through all the "url" in the "photo" array and display it on the feed page of my react native app. this is how i am doing

I have an app that is basically a calculator for users to add up a total amount they have won from certain games. when i input a figure that is

I would like to read the database child's title and display them in the database as a list view , how can this be possible ? here is my code that

I have created a sign up page that gets the user's email, username, fullname, password and profilepicture. problem is that firebase authentication

Will limiting a query to one result record, improve performance in a large(ish) mysql table if the table only has one matching result? for

A discussion about singletons in php has me thinking about this issue more and more. most people instruct that you shouldn't make

When the function to create or delete a list is called inside of my app the remaining lists are duplicated and displayed multiple times within the

I have an app that writes to the db on the firebase realtime database. i can see the data and its fine. i then simply want to read the

I have implemented the firebase real-time database presence system as shown in the official firebase documentation. i would like to make the

Whenever i click the sign in button in my app, it just crashes and shows an error. here is my activity_sign_in.xml and my signin.java.

I am working on real-time fire-base database. i have a issue in getting value what is changed in fire-base. i have client social database inside

I need help to get last insert id of the data, when i do insert record, i tried some code but it is not working for me, here i have added my code,

I'm using react-native-card-stack-swiper library in my react-native app. i'm using firebase realtime database for backend. expected

As the title, i am using infor/connection to check the connection from client to database but if i uninstall and reinstall app, the

I added in code the mapview, mkusertrackingbutton button, localmanager, dispatchgroup: let mapview: mkmapview = { let mapview

In the following json structure of friend requests "loniseyoartuayf2cj2zf6ezpqc" is the current user id. it has nested user ids of users from

I'm trying to save some data to all subscribers of a group whenever a new event is added to their group. it seems to work but somehow firebase

I set the urlstring variable in my viewcontroller but when i try to set the value for the "profileimageurl" in realtime database it doesn't show

I have datas on realtime database on firebase with the following structure : { "tests" : [ { "description" :

I keep getting error com.google.firebase.database.databaseexception: failed to convert value of type java.lang.long to string

I have tried many solutions this code worked for me in the morning and again when i am running it now it is showing an unknown error here is my

I'm trying to use the listview using array adapter on my fragment but when trying to do it using the tutorial, it crashes every time i open that

I have no idea how i can render this json on logcat

I am trying to display data that has been added to my firebase database to android. the data is uploaded to the database fine, but i get the

Aim save data within the group chat node current database tree

My blog class is here package com.nego.lakshan.nego; public class blog { private string from; private string to; private string

[] firebase.database.databaseexception: failed to

com.google.firebase.database.databaseexception: failed to convert value of type java.lang.long to string is

Basically, i'm trying to selectively copy a table from one database to another. i have two different [oracle] databases (e.g., running on

I'm working on database designs for a project management system as personal project and i've hit a snag. i want to implement a ticket

What are some strategies that people have had success with for maintaining a change history for data in a fairly complex database. one of the

Scenario: a stored procedure receives from code a datetime with, let's say datetime.now value, as a datetime parameter. the stored procedure

I have a new database table i need to create... it logically contains an id, a name, and a "value".

I am planning to create a pricing matrix for a project in rails. it's supposed to be a table of destinations and departure locations, and prices

I have a personal project i'm planning and i came to a small hurdle. i want to have an item with price that will be the default for all

I'm about to enter the 1st phases of designing a commodities trading application. a major function of this application is the capture and

Generally, how bad of a performance hit is storing a file in a database (specifically mssql) as opposed to the file system? i can't come up with

Phppgadmin comes with instructions for creating a reports

I wrote an application that currently runs against a local instance of mysql. i would like to centralize the db somewhere on the net, and share

Whenever i design a database, i always wonder if there is a best way of naming an item in my database. quite often i ask myself the following

Our software must be able to run on sql server 2000 and 2005. to simplify development, we're running our sql server 2005 databases in

I've always preferred to use long integers as primary keys in databases, for simplicity and (assumed) speed. but when using a

Two users wanted to share the same database, originally written in ms access, without conflicting with one another over a single mdb file.

Is there any way to use inheritance in database (specifically in sql server 2005)? suppose i have few field like

I have a self-referential role table that represents a tree structure id [int] auto increment name [varchar] parentid [int]

We've been having some issues with a sharepoint instance in a test environment. thankfully this is not production ;) the problems started when the

Hey i have a dataset uploaded in the following form: somekey -> alphabet -a: "['apple', 'ant']" -b: "['ball',

I am considering using firebase for an application that should people to use full-text search over a collection of a few thousand objects. i like

I have a database in access. the database has 4 tables: [department],

I have this request in oracle that is used by a php file $pub_request = oci_parse($conn, " select * from tp2_publicite p,

is the table i want to display information of employees who have more than 20 years of

I was recently introduced to mongodb and going through the installation guide i came to know that we have to first run the daemon (mongod) and

I am working on the slides offered

I have this following code which prints the department number and department name from dept table whose department number is less than 40.

Right now what i'm doing is: write some data in 3 different tables perform some reads to check if new values

If we specify column as decimal(5,2), which means we have precision is 5 and scale is 2. if i understand it correctly, precision is maximum

I am trying to write a block of sql code that compares two dates from two tables. one table shows when an item was acquired (ci_acquired_date).

Yesterday, i asked this question regarding best

I am trying to create a new table where 2 foreign key will be set public function up() {

When updating your system on archlinux with pacman -suy, pacman gets package databases from somewhere and then downloads

I am trying to delete several rows from a mysql 5.0.45 database: delete from bundle_inclusions; the client works

Function creategame(gameid, pin, currentdatetime, playername) { firebase.database().ref('games/' + gameid).set({ pin: pin,

Is there any way i can use the same controller and model for multiple databases? for example i have a product model, and a

I have created a hotspot server in mikrotik router. its successfully redirecting the users to default login.html and accepting the users i have

For our application, we keep large amounts of data indexed by three integer columns (source, type and time). loading significant chunks of that