Database Questions
Ad
How to get response from firebase after set?
Function creategame(gameid, pin, currentdatetime, playername) { firebase.database().ref('games/' + gameid).set({ pin: pin,
Laravel resource controller and model the same for multiple databases
Is there any way i can use the same controller and model for multiple databases? for example i have a product model, and a
connect mikrotik router hotspot default login.html to external database
I have created a hotspot server in mikrotik router. its successfully redirecting the users to default login.html and accepting the users i have
How is data compression more effective than indexing for search performance?
For our application, we keep large amounts of data indexed by three integer columns (source, type and time). loading significant chunks of that
Populate menu with a text file eg text.txt
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
Database design (MySql)::should we put html data in text field inside database table or more efficient to save inside text.txt file?
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
Parent node elimination using child value
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
What is a good way to open large files across a WAN?
I have an application deployed into multiple zones and there are some issues with opening larger documents (20-50mb) across the wan.
What is the difference between CouchDB and Lotus Notes?
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?
How do two-phase commits prevent last-second failure?
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
Ad
Getting data from an oracle database as a CSV file (or any other custom text format)
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
Can I have additional fields on the users table in CakePHP & still use the built-in auth methods?
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
Critique my auth system DB schema?
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
Multiple posts to DB with Linq
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
"Similar Posts" like functionality using MS SQL Server?
I have lots of article store in ms sql server 2005 database in a table called articles- "articles (articleid, articletitle,
Pass JSON data from JavaScript in view to controller in laravel
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.
How can I get username from real time database and show it in navigation header?
register button in register acvtivity
SQL to fetch value of one column such that a certain value in another column does not exist
I have the following table t key value
How can I set up my firebase rules so only content-owners have read and write to their data?
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
What are the best practices for creating and cleaning large JSON files?
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
Laravel eloquent update, 500 Internal Server Error
I want to update my database with laravel eloquent update, but response is always 500 this is my model class
Ad
Replace embedded fields in mongo DB
I have the following collection: [ { "_id": "6021d4e8de525e00bb3623f1", ...otherfields,
Make the result of input 1 and input 2 appear in input 3 automatically
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
Generate random numbers from a normal distribution
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=
select info from database to ul by id and open it in new window
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
SSL to log in, regular http after that... how vulnerable is the data transferred from the database?
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
How to log in an Oracle database?
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
What is the Best Way to Represent Summer Time Rules?
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
How do I enforce data integrity rules in my database?
I'm designing this collection of classes and abstract (mustinherit) classes…
What would a Database Diagram (ER Diagram/Table Layout) look like for measuring distribution of something?
If i was, for example, going to count "activities" across many computers and show a rollup of that activity, what would the database look
go grammes - how to get property from gremlin, not just the value with go grammes
Hello i'm using golang package "github.com/northwesternmutual/grammes" and want to get the field not just the value from response client
SQL schema to hold history of employee actions when employees come/go/get promoted, etc
I'm writing an app that contains the following tables: (1) employee_type, (2) employee and (3) employee_action. employee_action is
Ad
Suggestions for implementing audit tables in SQL Server?
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
load data local infile imports only 200k out of 400k records
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
decrement value database if availability greater of request
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
PowerBI: Giving users the option to include or exclude a type of data
I'm creating my first powerbi report, analysing staff absence data. the data contains a field of 'absence type', which categorises the type of
Robot Framework connectivity with database
Connect to database psycopg2 connectiondetails ${count}= row count select count(*) from trial; log to console
Database design - How should we design a teacher/student relationship when student records themselves also need to be associated to each other
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
How to count values on a pivot table in MySQL?
I have two tables users and get_cal like below : users
Keep getting Type_Error in Python when trying to solve with formula containing >
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
What is the most correct approach for nested database in Room?
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
Laravel 7 API Resource showing only data that contains relationship
This my code stored in my api controller: return apartmentresource::collection(apartment::with(['sponsors'])->paginate(5));
How to make a table in SQL that tracks people entered by the hour, but also stores the date?
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
Ad
SQL - JOIN TABLE A AND TABLE B SO THAT EACH ROW STATES WHICH TABLE IT COMES FROM, A, B OR BOTH
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
Filter query result for every Thursday of a given month
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
How can i update a record of specfic user from start date of moth till the end of that specific month?
Database columns image update `agentstats` set
How to read multiple JSON entry's without python error
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
My flutter app fails to connect to FastApi
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
Count distinct by boolean value
Is there a better (prettier, more idiomatic, or even performant) way to do the following? objective: calculate distinct values for a column
Understanding how to model UML Class/Database
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
Firebase Realtime Database wait until the data is retrieved
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
React Rendering a collection correctly
I am using react-firebase-hooks
Anonymous "likes/reactions" using Firebase
Question from junior padawan to real jedy. i'm developing a website for a designer portfolio. without any registration and backend. i'm
How do I save an audio file into Firebase Realtime Database?
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
Ad
Data validation issue Firebase RealTime Database rules
I am trying to make some security rules to allow authenticated users to access (read / write) chats path based on some conditions for
How can I retrieve data from all sub-nodes of a node from Firebase?
I have a firebase database that looks like this
MS SQL to DynamoDB migration, what's the best partition key to chose in my case
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
python mysql insert error
I keep getting the error information after running this line of code query = ("insert into movies"
Exception Occur in VB.NET code
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
Using nested query to improve SELECT performance in MySQL
I want to store multiple mptt (modified preorder travelsal trees) in one mysql table with the following columns: node_id, user_id, rht, lft,
Store enum in database
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
JSON files to array
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:
How to force the update of radio buttons in Webix datatable
Is there a way to force the update for each change of the radio buttons in webix datatable? i have a datatable like var
uwp connect to sql
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
simple database solution (local storage) from bash
I am searching for an simple data storage solution, interfaced from local bash (write and read). background: i'm collecting sensor data
Ad
#1005 - Can't create table 'addfriend.updates' (errno: 150)
I want to create this table but it just split off with this error: 1005 - can't create table 'jotech.updates' (errno: 150) a
Incompatible data types while ALTER table in HSQL with Hibernate
How fix next error? error schemaexport:484 - hhh000389: unsuccessful: alter table category_relations add constraint
many-to-many database
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
Filtering objects with null property on Realm for React Native
React native and realm noob here! i want to load objects where one particular property is null. i tried to filter them like
How to Insert records into a table in Unity using SQLite?
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
The database cannot be opened because it is version 706
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:
PHP script displaying a blank page
This is my script and it's displaying a blank, i have no idea what the problem is. help!!!! #new to php <?php include
How to insert large text into a DB with PHP?
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 want to implement database to my java web app
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
(SQL) Query Results on one row
So i have two tables, named "questions" and answers
Store spss data on SQL database based on uniqueidentifier
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
Ad
How can I cause an UPDATE query to throw an error?
In my database i have the following table table "public.session" column | type | modifiers
no such table:(code 1) error
I have error // no such table: pbook (code 1) in my code private static final string table_name = "pbook"; private static
What is the best practice database design for transactions aggregation?
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
SQL group by and where on each group
I have a table with columns like sourceid (guid), state (1:deactivated, 2:activated, 3:dead), modifieddate. i am writing a query to
Importing single MySQL .sql file for ENTIRE Database | No Database Selected Error
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
php only updating first database entry regardless of what entry i try to update
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
Retrieve data from firebase and create marker
I would like to ask how to retrieve the data from firebase which is to get specific data. my firebase database is look like
How to clear tableView data and reloadData every time view loads again
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
Get Firebase UID when push, then push again with the given UID in Java
Hi i have the following code written in javascript and i need to do the same in java, there's the code:
how to limit button clicked by time passed swift
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
Writing data to Firebase with NAME as key
I have a small react app and i want to write a user to firebase realtime database writeuserdata(response.id,
Ad
mysql---how to design the guestbook database?
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
Offline GuestBook with Pen-Input and PC-Camera Input
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
Unable to get data collector to display values (Keeps displaying None value)
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
In a MySql query how to return the names of the people who are reported to
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
Query to String from Room Database
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
PHP MySQL, Find Tables with variations of a name
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
Postgres database export and import, problem with $$PATH$$
I am in the process of doing export and import with postgres database. i had used the following command to take the backup of
Laravel Ajax fetch data one to many relationship
I'm trying to fetch data from one to many relationship via ajax call. my restaurantoffer_table table: id |
R database connection encoding mistakes with accents
I am connecting to a sql server database using this code: dbi::dbconnect(odbc(), driver = "...",
Is there a way to implement cassandra "decimal" Datatype in Golang
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
getColumnIndex("") doesn't recognized
That's the code getcolumnindex() displays with a red color.
Ad
How do I connect to a MySQL Database in Python with a RaspberryPi
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
How to retrieve an object from ResultSet in java?
So i tried to make a getrecord class to retrieves info from database based on the id the user entered, public student
Ad
Blog Categories
Ad