A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information.Use this tag if you have questions about ...

learn more…| top users | synonyms (4)

-1
votes
0answers
12 views

I need to send data from my ios app somewhere so I can view it

I am working on an app, and in order to test the app, I need users to use it, and I need user inputted data (not diagnostic results) to be sent somewhere for me to view them. What is the best way to ...
-1
votes
0answers
6 views

Securing access to SQL Server from a distributed .NET WinForms application without Windows Authentication

In the past, the only client I distributed my software to hosted it locally and required their users to be on the domain (either on-site LAN or VPN connection) in order to connect to their database. ...
0
votes
3answers
6k views

Send information (from a form) to a database and email

I have a form that allows a user to opt in to receive a notification if a new product comes out. Currently, a users' information is validated and sent to a database. However, I also need it to be sent ...
0
votes
1answer
17 views

How do I return rows with a specific value first and rest all the values of a table in a Alphabetic order

I need to get book_name and book_code order by book_name in alphabetic order.Input to my query is Author_code.I have three tables:Table1: Books (Independent Table which will have all the books)...
0
votes
0answers
6 views

Firebase Database Web

I am having issues trying to figure this out. I come from a SQL background and am new to Firebase database. I am building a website that sells individual videos online. What I am trying to do seems ...
1
vote
0answers
10 views

Matching url to cell data

I've made a struct array which holds text and a URL. I'm parsing data from an XML URL, which then I use that data to put on a label from the struct using a for loopcell from TableViewthen in ...
161
votes
2answers
225k views

How to create user for a db in postgresql? [closed]

I have installed PostgreSQL 8.4 on my CentOS server and connected to root user from shell and accessing the PostgreSQL shell.I created the database and user in PostgreSQL.While trying to connect ...
5
votes
2answers
16k views

Can Microsoft Access autocomplete fields?

I'm using Microsoft Access 2007. When I start typing a new record,is there a way to get access to suggest things I've previously typed, to save me time typing the whole word in? For example when I ...
11
votes
6answers
473 views

How to insert millions of data of different RDBMS in to SQL Server database with insert statement?

I have two databases in my SQL Server with each database containing 1 single table as of now.I have 2 database like below :1) Db1 (MySQL)2) Db2 (Oracle)Now what I want to do is fill my ...
58
votes
5answers
98k views

SQL query to find record with ID not in another table

I have two tables with binding primary key in database and I desire to find a disjoint set between them. For example,Table1 has columns (ID, Name) and sample data: (1 ,John), (2, Peter), (3, Mary) ...
0
votes
2answers
9k views

How to connect Android Studio with SQL Server database?

We are currently having the same problem as here: How to connect Android Studio with SQL Server database, but it hasn't been answered.We also succeeded the connection on Eclipse, using the sqljdb4....
0
votes
1answer
19 views

Using AsyncTask in Activity fails

I have an application in which I wanted to store a list of items and I figured a database would do. I found out about the new Room API and tried using it, though I'm having some trouble getting it ...
0
votes
0answers
13 views

Can SQL reads return stale data?

Consider the following SQL transaction sequence:// @TransactionOneBEGIN TRANSACTION;CREATE TABLE T (C INT, D INT);INSERT INTO T VALUES (1, 2);COMMIT;// @TransactionTwoBEGIN TRANSACTION;...
0
votes
0answers
24 views

attendance form : delete and submit using the same form

I have an attendance table which has a student_id and lesson_id columns.in a form that has every student name beside a checkbox if the student attend this lesson the checkbox would be checked@...
0
votes
0answers
14 views

H2. Insert String to VARBINARY(255)

I have problems with adding data to h2 table, into a column of type VARBINARY(255).Table USERID BIGINT(19) NOT NULL auto_incrementUSERNAME VARCHAR(255) NOT NULLPASSWORD VARCHAR(255) NOT NULL...
-2
votes
0answers
6 views

what is region overlap in hbase?

by googling, I only got this http://hbase.apache.org/0.94/book/apbs04.htmlbut it does not answer my question about 'what is region overlap in hbase'can someone explain a little or give me some ...
0
votes
1answer
20 views

Is it more efficient to query a view from a stored procedure or include the table join in the stored procedure?

I have a database structure similar to Instagram, where I have a table containing paths to pictures in a file system and a table containing user information as such:Users:ID | userName | age | ...
-1
votes
0answers
21 views

Database - get a diff between to states in oracle database

I'm looking for a way to get a diff of tow states (S1, S2) in a database (oracle) to compare and see what has changed between these two states. Best would be to see what statements I would have to ...
-4
votes
0answers
35 views

PHP not receiving data when using 3g/4g

I have a PHP code that is supposed to receive data from my database and echo all the data. It works perfectly fine with Wifi, but with 3g/4g it does not echo the right stuff. There are no errors, it ...
-2
votes
0answers
31 views

Retrive specific data from joined MySql tables [on hold]

I'm new to coding. I'm trying to build a simple web application for a exercise class using Codeigniter and MySql to handle payments of members. I'm trying to retrieve some specific data from few ...
4
votes
0answers
226 views

Magento 1.7 - How to stop DB backup that was initiated through deleting a website?

I have 61 websites on a live Magento instance. 10 or so are no longer used but we get about a thousand orders per week and have been running on Magento for over 2 years. I went to delete one of the ...
15
votes
5answers
3k views

Doing a rollback - Repository integration tests

I want to implement integration tests of my Entity Framework driven repositories. The problem is how to rollback database state after tests are done. At the moment I'm planning to start transaction at ...
0
votes
1answer
20 views

PHP database foreign key

I have this piece of codeCONSTRAINT has FOREIGN KEY(fk_AirFareAfID) REFERENCES AirFare(AfID) and it's giving me this error: #1064 - You have an error in your SQL syntax; check the manual that ...
-8
votes
0answers
20 views

Can someone please provide the database structure for a 1 to 1 chat application in android… [on hold]

I tried using the example application from google codelabs but thats a group chat room... i've been trying to get the database structure for weeks now and not able to... can someone please provide the ...
0
votes
0answers
9 views

Atom editor root certificate database cannot be managed - SSL verification issue

I liked the Atom editor a lot. However, my company cannot approve it because the root certificate database cannot be managed and this compromises SSL verification process. I am not a security expert. ...
-1
votes
1answer
116 views

Couchbase vs MongoDB in terms of ease of administration and maintenance

As we know that both Couchbase and MongoDB are document NoSQL stores. Would like to understand the difference between both in terms of operational/administration complexity and maintenance. Which ...
0
votes
0answers
15 views

Best database type to store data that will be used with a blockchain?

For a project, I'm using Hyperledger Composer Fabric to create a blockchain for an integrated healthcare system for integrity and fast access purposes. I don't want to store the actual healthcare ...
0
votes
0answers
13 views

how to store a python dictionary into mysql DB - while excluding certain records

i am trying to take the data from a dictionary (the example is simplified for readability) and insert it into a mysql database. I have the following piece of code.import pymysql conn=pymysql....
0
votes
1answer
32 views

node.js - Mongodb query on text field not returning results

I have the following query in node.jslet rootWords=await wordCollection.find({wordName: Word.wordName}).toArray();It doesn't return any results when Word.wordName only consists of one character....
0
votes
1answer
13 views

Using React-Native and AWS NoSQL

I'm looking to save users' progress to a database and I'm already using AWS for user authentication. There's an option to add NoSQL support to my AWS project, but there is virtually 0 documentation ...
0
votes
2answers
31 views

Shifting certain rows to the left in pandas dataframe

I have a pandas database of some sports data. The columns are name, age, birth city, birth country, rookie, weight, and problem. The original data had birthcity as "City,State" for American players, ...
0
votes
0answers
21 views

Data which relates to multiple Schemas in MongoDB?

I have a front-end app which sometimes requests all the days of a month, sometimes the weeks of the year (more precisely: the days these weeks contain);I thought of saving everything in mongodb like ...
-1
votes
0answers
20 views

Database Design - How can I do that?

Lets assume that we are working with millions of images that look like:and also consider the following structure:Everyone of the folders will contain many sub folders and every sub folder will ...
0
votes
1answer
12 views

Is any way to store form data without using database?

I am developing a registration application where registration details will be saved and at the time of login as per the user's registration details, the output will be displayed. So first we have to ...
-1
votes
0answers
13 views

Using CakePHP Show Values from a Table Based on Foreign Key from Second Table

I am new to CakePHP. I want to achieve a simple task but I am really not able to figure it out on my own. I want to display data from Database Table: Solar Products which has Type of Products saved ...
1
vote
1answer
20 views

RDBM dynamic table structure

I am trying to create a dynamic table.ID |TABLE_NAME | COLUMN_NAME| VALUE | CRITERIA_COLUMN | CRITERIA_VALUE------------------------------------------------------------------------------1 |...
-1
votes
0answers
26 views

ORA-00904: “STATUS”: invalid identifier [on hold]

I have loaded a page which is retrieving the data from the database. Now on this current page I have made a option bar. Now by selecting any option from the option bar I want to send all the data to ...
0
votes
2answers
6k views

Mysqli check if username already exists

Yes I know this has been asked before and I literally copied code from multiple answers from this site trying to get it to work. This is the code I've been using now but it keeps allowing me to enter ...
2
votes
2answers
32k views

How to store and retrieve images in sql server database through VB.NET

SQL Server supports the ability for clients to storeobjects within tables.Create Field that data type Image and Initialize byte array with a null value initially.Use FileInfo object to get file ...
-1
votes
0answers
15 views

How am I getting the undefined index [duplicate]

I'm trying to update my database using a dropdown. Basically it automatically the table value automatically updates whenever I made a selection from the dropdown. For some reason, I get the error ...
-1
votes
0answers
15 views

Service-based database (.mdf)

I have designed my Windows Forms application. I added service-based database to my project (myDatabase.mdf) including number of tables to keep my inserted data. However, I want to move my project to ...
140
votes
3answers
189k views

Run postgresql queries from the command line

I inserted a data into a table....I wanna see now whole table with rows and columns and data. How I can display it through command?
-2
votes
2answers
29 views

Form Not Posting To SQL Database [duplicate]

I have this form and I can’t get it to post to my sql database?https://xcanberracars.com/assets/booking/bookride_bu240118.phpThis is the code I believe I have everything right but obviously not. ...
0
votes
0answers
13 views

Modelling DAG in Database for efficient querying for all free nodes

I am designing a Task Dependency Management System(TDMS), which will be responsible for managing dependency among client's tasks.For example, a client can tell TDMS that it has 5 tasks - A, B, C and ...
-3
votes
0answers
23 views

DatabaseError: Permission denied firebase (with rules correctly put)

I have some problem to get few data on my Firebase, the name and the imageUrl. And i don't know why !I need some, help, this is my first application..My rules:{"rules": {".read": true,...
-2
votes
1answer
36 views
+50

How decentralized database works?

How decentralized database works from technical point of view.In general I understand that all the users have its own copy of data and somehow it gets in sync.But this sync logic totally not clear ...
-1
votes
1answer
33 views

How to use end loop for cursor loop in mysql

The following code was used for finding the first five highest paid employee from a table named employee7 and add the details to another table named temp using cursor in mysql but I got the error ...
-2
votes
0answers
21 views

Database/Excel import and export format

We have a database program that can export and import excel sheets. The excel sheets it exports are formatted as text, I've noticed you cannot change the formatting in these exports without performing ...
0
votes
0answers
6 views

Database Mapping - How to map dynamic text fields

1) I have a form structure that allow user to create dynamic fields. The text fields are mapped like:a) Text: varchar(255). For simple text;b) Textarea: varchar(2000). For descriptions, instructions,...
0
votes
2answers
10 views

Google Cloud Datastore Update Entity: Node.js Client

How to update GCP datastore entity in nodejs. // Saves the entitydatastore.save(task).then(()=> {console.log(`Saved ${task.key.name}: ${task.data.description}`);}).catch(err=> {...

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,