Database Questions

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

I am trying to build a kiosk on a local machine only. i'm planning to use javascript to make the menu lists functional. here is my html code

We building big web application and we use mysql, we want to make mysql database more fast. some of us think if we will put message html body

I am using firebase for my application and would like to be able to delete a parent node via its child value. i have already tried several

I have an application deployed into multiple zones and there are some issues with opening larger documents (20-50mb) across the wan.

I was looking into the possibility of using couchdb. i heard that it was similar to lotus notes which everyone loves to hate. is this true?

I am studying how two-phase commit works across a distributed transaction. it is my understanding that in the last part of the phase the

A sample perl script that connects to an oracle database, does a simple select query, and spits the results to stdout in csv format would be

I'm using cakephp and i want to add a first and last name column to the users table, but when i pass through the field values

I'm designing a restful web app that will provide an authentication system for several other apps. the other apps will query this app through http

If i have two thousand webusers each sumbmitting a post to sqldb through website at the same time same tables, will linq handle this without any

I have lots of article store in ms sql server 2005 database in a table called articles- "articles (articleid, articletitle,

I have a web application where i fetch json data from a database table, edit it, and want to ultimately insert it back into the database.

register button in register acvtivity

I have the following table t key value

I have checked the documentation but i am not sure how to apply that rule to my specific data structure, please check how my data is organized and

I am new to programming and i have come across lots of huge json files, i would like to create my own, how does one generate, clean and format

I want to update my database with laravel eloquent update, but response is always 500 this is my model class

I have the following collection: [ { "_id": "6021d4e8de525e00bb3623f1", ...otherfields,

I just want to make the result of input 1 and input 2 appear in input 3 without clicking any button or text. it means if user write number 5 in

I couldn't create normal distribution with python. i tried this but not worked exactly. def prove_nd(num,mean=3,std_dev=1.25): n=

I have this code to select some info from database to ul and open it in new window by id , the problem here is the same row open in the new window

I roamed the site for this question using the search engine, and i don't think it's out there. if it is, apologies in advance and feel free to

I am interested in what methods of logging is frequent in an oracle database. our method is the following: we create a log table for the

I need to store the summer time (daylight saving time) change-over rules for different world regions in a database. i already have a way of

I'm designing this collection of classes and abstract (mustinherit) classes…

If i was, for example, going to count "activities" across many computers and show a rollup of that activity, what would the database look

Hello i'm using golang package "github.com/northwesternmutual/grammes" and want to get the field not just the value from response client

I'm writing an app that contains the following tables: (1) employee_type, (2) employee and (3) employee_action. employee_action is

One simple method i've used in the past is basically just creating a second table whose structure mirrors the one i want to audit, and then create

Hello! i am new to mysql so kindly explain in as simple language as possible! i have a csv with 400k rows and want to

There is a way through query to scale the quantity of a product that can be double on the table because it comes from 2 different orders taking

I'm creating my first powerbi report, analysing staff absence data. the data contains a field of 'absence type', which categorises the type of

Connect to database psycopg2 connectiondetails ${count}= row count select count(*) from trial; log to console

So this is something that we've been struggling to try and figure out how to optimize. in a simple world, this might be solved by a

I have two tables users and get_cal like below : users

I need to print all the values from xml data that are more than the average. i figured out how to solve for the average but i'm having trouble

I'm considering creating a schema with both one-to-many and many-to-many elements. as i am a bit of a novice in this matter, i searched some

This my code stored in my api controller: return apartmentresource::collection(apartment::with(['sponsors'])->paginate(5));

I am using an hikvision dual lens people counting camera that tracks the amount of people that enter/exit a location by the hour. the data that is

You have two tables a and b, both tables have the same columns but different rows, some rows exist in both table a and b, some rows only exist in

I have a sql table with 2 columns id (int) and createdate (datetime) type. i want to filter all the ids for each thursday for a given month

Database columns image update `agentstats` set

I am trying to make a simple python program with a tkinter gui that can take a user input and add it to a json file. then there will be another

I have been trying for ages and can't figure it out, i hope you can help me. i have my sql database running as well as fastapi. fastapi is running

Is there a better (prettier, more idiomatic, or even performant) way to do the following? objective: calculate distinct values for a column

I'm confused with designing a client software with database integration to what should be a member variable of the class or just a query to the

I have a map containing the keys of my firebase realtime database and want to retrieve the corresponding key data and put it in the result data

I am using react-firebase-hooks

Question from junior padawan to real jedy. i'm developing a website for a designer portfolio. without any registration and backend. i'm

I finished setting up my app's functionality to save text-based messages to rtdb (see code below). i now need to be able to save a voice recording

I am trying to make some security rules to allow authenticated users to access (read / write) chats path based on some conditions for

I have a firebase database that looks like this

I am working on a migration from ms sql to dynamodb and i'm not sure what's the best hash key for my purpose. in ms sql i've an item table where i

I keep getting the error information after running this line of code query = ("insert into movies"

I was doing vb.net and use it to connect my sql database. right now i want to insert the data into my database, yet after i finish my code it

I want to store multiple mptt (modified preorder travelsal trees) in one mysql table with the following columns: node_id, user_id, rht, lft,

I have a database for a job advertisement web application for an assignment at university. i have a lot of enumeration values in database such as

I have a heart.json file that i need transfer to a database and looking for a solution. in the file i have the following data:

Is there a way to force the update for each change of the radio buttons in webix datatable? i have a datatable like var

I am writing an uwp app, and i need to store data to cloud database. i used google cloud sql service and i can manage my database by

I am searching for an simple data storage solution, interfaced from local bash (write and read). background: i'm collecting sensor data

I want to create this table but it just split off with this error: 1005 - can't create table 'jotech.updates' (errno: 150) a

How fix next error? error schemaexport:484 - hhh000389: unsuccessful: alter table category_relations add constraint

I'm trying to create a database to analyze the configurations of my servers. but i have many services that can run on many servers (for

React native and realm noob here! i want to load objects where one particular property is null. i tried to filter them like

I'm trying to add a record to my table using string variables for varchar columns. i want to insert the values i give it under the next

I have the problem that i am using visual studio 2013 to create a mdf file and then open it like it is described in this tutorial:

This is my script and it's displaying a blank, i have no idea what the problem is. help!!!! #new to php <?php include

I have a function that generates a random text with about 8,000 characters. this text is generated at the time of first access the page,

I am newbie with database. i have knowledge of java. i am using play framework(java not scala) to develop a web app. now for storing

So i have two tables, named "questions" and answers

I imported a table from sql database to spss dataset, i edited the table by adding a new column to it after some statistics, but when i try to

In my database i have the following table table "public.session" column | type | modifiers

I have error // no such table: pbook (code 1) in my code private static final string table_name = "pbook"; private static

I am designing a database which will hold transaction level data. it will work the same way as a bank account - debits/credits to an account

I have a table with columns like sourceid (guid), state (1:deactivated, 2:activated, 3:dead), modifieddate. i am writing a query to

I know it's probably not the correct way to do it, but i exported my entire database to a file called localhost.sql. i don't know how to import

So i'm doing a project for school, and i am trying to update certain items in column for certain rows in my database, however, regardless of what

I would like to ask how to retrieve the data from firebase which is to get specific data. my firebase database is look like

I am fetching data from firebase realtime database into my tableview and the cells upon click open a new view with the data from the tableview

Hi i have the following code written in javascript and i need to do the same in java, there's the code:

I need a button where the user clicks to let everyone know they are attending a location, but i only want it to be able to be clicked up to 3

I have a small react app and i want to write a user to firebase realtime database writeuserdata(response.id,

I am a new learner of php, now, i want to write a guestbook. but i don't know how to design the guestbook database. expect someone can give me

I have a requirement to create a offline guestbook on windows vista platform. the visitors will use the lenovo tablet pc to write their feedback

Hello i am currently using python telegram bot to create my bot, currently i am unable to use my data collector (which also functions to calculate

I had this question during a test of a company, in mysql: how to return the names of the people who are reported to (excluding nulls) the number

How do i create a query to my room database from example the sum of a database column then convert it to a string to then populate text fields in

I have one or more tables in my mysql db. named: 'sci-01-123' and 'sci-01-123-1', etc. i want to search for all table names with the base

I am in the process of doing export and import with postgres database. i had used the following command to take the backup of

I'm trying to fetch data from one to many relationship via ajax call. my restaurantoffer_table table: id |

I am connecting to a sql server database using this code: dbi::dbconnect(odbc(), driver = "...",

I have a database field that is set to decimal, while in my go project i am having problem choosing which datatype can be use. each time i send a

That's the code getcolumnindex() displays with a red color.

I'm a student and i'm trying to write some sensor values into a mysql database. as ide i'll be using inteliji. first off i started by

So i tried to make a getrecord class to retrieves info from database based on the id the user entered, public student