I want to condense my database, which now contains a large number of values, to 1/12 of the original size by averaging twelve consecutive values. To do this, I form the mean value using the types TIMESTAMP and FLOAT(4,2). In…
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) =>…
I have an Athena table with a string column which looks like: +-------------------+ | employee_size | +-------------------+ | GREATER THAN 2000 | +-------------------+ | 500 - 999 | +-------------------+ | 28.00 | +-------------------+ | unknown | +-------------------+ | 563 |…
I am working with an api written in php, that is getting data from a postgres database. one of the fields of data is however getting returned by the query as lexicographic sorted. I thus want to try casting it…
I have data received from backend as following: id: number; user_id: number; car_brand: string; car_model: string; vin: string; equipment: string; reg_number: string; car_mileage: number; car_year: string; and i have an interface in frontend as following: UserCarType id: number; user_id: number;…
I have class with constructor that can accept object of two types, and then based on what type of object it got, perform different actions. I've seen that it's possible to use as keyword for that. But it feels wrong…
I am a complete flutter and sqflite beginner. I am trying to make my calendar events persist over app restarts so I am implementing an SQFlite database. However, I keep running into this error and have no idea what is…
I need to cast a List and a Map of unknown types to specific types. If the List or Map are not empty all is well. But if they are ever empty I get a cast error. When list is…
Is there a built-in function to truncate values of one type to fit the range of another type? E.g casting a INTEGER to SMALLINT. This might fail if the INTEGER is larger than SMALLINT can hold. I would like the…
I have a class and an interface as follows: internal class DoStuff { public int X { get; } public void Do() => WriteLine(X); public DoStuff(int X) => this.X = X; } internal interface IDoStuff { void Do(); } The…