I've been stumped trying to optimize this query and was hoping some of you database wizards might have some insight. Here is the setup. Using TimescaleDB as my database, I have a wide table containing sensor data, it looks like…
i have table in database called land with a field landType , landType is an array of strings (string[]) i need to write a query that by taking an input for example "N" it returns the row if any of…
To keep it simple, I'm creating a list of of items in React that are pulled from the DB. Part of this is that we can delete/add items to the list, which i also want to reflect in the DB.…
I have a PostgreSQL trigger that fires after an INSERT on the auth.users table, calling a function handle_new_user() which, in turn, calls insert_into_profiles() to add user data to another table. The insert_into_profiles function is defined as follows: CREATE OR REPLACE…
I want to identify who is on my app so I can place green badges as indicators. I logged into my app (which I have not deployed) through Google OAuth, so the session is stored. However, I left days ago…
Cant connect to MongoDB database and store data in localhost:27017 using MongoClient. Cant display connection result in the console (both failure and success connections). var express = require('express'); var router = express.Router(); var mongoClient = require('mongodb').MongoClient /* GET home page.…
I'm trying to retrieve data from a database, and have made these two methods inside of a certain "TodoDB" class: Future<List<SurveyData>> fetchAll() async { final database = await DatabaseService().database; final survey = await database.rawQuery('''SELECT * from $tableName'''); return survey.map((survey) =>…
First, I set John to the user-defined variable @name as shown below: SET @name = 'John'; Then, I set David to @name in a transaction, then rollbacked as shown below: BEGIN; SET @name = 'David'; ROLLBACK; But, @name was not…
I am currently struggling with rendering some images on my React Native application. Currently, my app is connected to a database, which contains the image file names (ex: 'swipe1') that I want to render in my FlatList. However, it is…
I have a SQL database for maintaining D&D games which has tables for things like Characters, Items, and Locations. I want to start modelling the relationships between all these different entity types, such as the relationship a Character has with…