i want to move from SQLite database M, MySQL database. if i understood correctly, so i can do it with changing the engine: engine = create_engine('sqlite:///foo
I'm looking to leverage Azure deployment slots for a production Web App (with Azure SQL DB). I also use a Fortiweb WAF-as-a-Service for production app. If I use
I'm looking to leverage Azure deployment slots for a production Web App (with Azure SQL DB). I also use a Fortiweb WAF-as-a-Service for production app. If I use
How can I ensure that the = operator is always rendered case-insensitive? Are comparisions with the LOWER or the UPPER functions the best bet for performance? I
I have a records collection with the following indexes: {"_id":1} {"car.make":1,"city":1,"car.mileage":1} And performing the following query: db.records.agg
it it possible to write script in hana that crate temporary table that is based on existing table (with no need to define columns and columns types hard coded
I am a little bit confused between non-prime attribute and non-key attribute I have searched a bit about them and found that non-prime attribute means An attri
I'm trying to remove a model from database using ModelService in my groovy script but it doesn't remove. import de.hybris.platform.core.model.order.OrderModel i
Mysql - phpmyadmin What's wrong with this query? ALTER TABLE `invoices` CHANGE `status` `status` ENUM('paid','due','canceled','partial','cheque') CHARACTER SE
I have project that I need to display a leaderboard of the top 20, and if the user not in the leaderboard they will appear in the 21st place with their current
We are a using a micro-service based pattern for our project where we have Users and their Orders. Users personal information (name, email, mobile) is stored in
I want To Select stockDate in ASC Order My Table Structure is.:-
I'm new to Postgres and I have a confusing one. Basically, I want to find if my post is bookmarked by the user or not in a new field bookmarked = true / false H
I'm trying to bind an array in a raw WHERE IN query in the Laravel DB example: $arr = [1,2,3]; DB::select(DB::raw("select * from test1 WHERE id IN ? "), [$arr
I'm trying to draw a graph with some arrays. I got 4 arrays (Time,Temprature,Speed,Water). I want to add Time array on AxisX. The others are going to be on Axis
I retrieve data from mysql server and one of the fields is an int value (1 or 0 ) and it's printed right (1 or zero ) but when I try to apply an if condition on
I am a beginner making use of a Roomdatabase. Mostly using it to load in and pass items between tables using simple relationships. package com.example.allin
I have database size is more than 125 GB . and every 1 hour the database is not respond . the message is every time say (The transaction log for database MESP_2
I'm trying to export a dictionary of words in sqlite made up only of words that start with, contain, or end with specific filters. If one filter was 'ment' and
In my project, using Quarkus, Angular and PostgreSQL DB, when I run the backend & and the frontend in dev Mode, I can connect to the DB (which is postgreSQL