sqlite

We started making an application similar to blablacar in terms of functionality. The question arose, which database to use?! ... tion to use firestore, but there are also restrictions. Next in line is SQLite, but is it suitable for such an application?!

Trying to output a table via python def verification(): connection = DataBase.getConnection_log() try: ... | time | YES | | NULL | | +--------------------+--------------+------+-----+---------+-------+

As you know, in Android Q (API=29), Google once again changed the rules for accessing external memory (external storage) and ... rd design: SQLiteDatabase db=SQLiteDatabase.openDatabase(file.getPath(), null, SQLiteDatabase.OPEN_READWRITE);

Model: from django.contrib.auth.models import User from django.core.exceptions import ValidationError from django.db import ... rors, status=status.HTTP_400_BAD_REQUEST) Mistake: NOT NULL constraint failed: studentapp_studentproject.project_owner_id

I want to add records to the table while checking whether there is a record with certain values in the database. I do somethi ... начение2' AS Поле2 'Значение3' AS Поле3 WHERE NOT EXISTS( SELECT NULL FROM Baza WHERE (Поле1='Значение1')) LIMIT 0,1

There is a table with "dishes" and their "ingredients": id title ingr 1 яичница яйца 2 ... ith the same ingredients? Input data: ['яйца', 'соль'] Output: ['яичница', 'соль с яйцами'] Http://sqlfiddle.com/#!7/386f1/3

How can I merge two tables using sql queries? There is such a table: CREATE TABLE [dolgnosty] ( [id] INTEGER PRIMARY KEY, ... able dolgnosty is unchanged, and the table stavky changes, but, all this should be shown as a single table! How do I do this?

Hello. I'm just starting to learn programming, I've dug through a bunch of examples and lessons, but things are not moving fo ... in the database (the database contains the name and address, you need to search only by address and output the name+address)?

Created the database via SQLiteStudio (3.2.1). CREATE TABLE ranobes ( ranobe_id INTEGER PRIMARY KEY AUTOINCREMENT, ... ALUES, id, and manually registered it, now the record was added, but without taking into account AUTOINCREMENT. What's wrong?

1.What is the percentage of orders with a discount? 2. What is the most popular discount (name) and what is the total cost of ... Database are given: 1.orders (id, disc_id) 2.discounts (id, name, count) Name-name of the discount count-discount in rubles

Good afternoon! There is a table with records in sqlite. In Activiti, I have to display the entry on the screen in the prepar ... umnIndex("date"); int monthColIndex = c.getColumnIndex("month"); int yearColIndex = c.getColumnIndex("year"); .... and so on

There is a column guildToken of type TEXT, and I'm trying to get a value from it: pyguild = (ctx.guild.id,) cur.execute( ... rBotForDiscord-master\helper.py", line 163, in checkDB print(cur.execute( ValueError: parameters are of unsupported type

Good afternoon, gentlemen. I ran into the fact that the hint/highlighting methods do not work. The screenshot shows that if ... s configured or the sqlite3 module is crookedly installed? maybe something is wrong in the code? just started learning python

Can you describe in detail the sql code for creating polymorphic relationships? For example, let there be 4 tables: Students, ... where the first column is the id from any linked table, and the second is the name of the table from which this id is taken.

I try to install SQLite in Haskell, but it gives an error: D:\hq>cabal install sqlite-simple Resolving dependencies... Up ... s in target: sqlite-simple. Perhaps you want to use --lib to install libraries instead. Can you tell me what to do about it?

Is there any information on the volume of SQLite DBMS data types (for example, integer-1 byte, real -..., etc.). I can't find the source for calculating the volume of my database in bytes, I need to add up all the data types.

I just understand Android. There is a fragment: public View onCreateView(LayoutInflater inflater, ViewGroup container, ... ppearanceLarge" android:text="Large Text" android:id="@+id/textView2" android:layout_gravity="right|top" />

I'm a novice programmer. I have a dictionary app. The database is compiled in SQLite. As new words are added, the ordinal nu ... ron', 'pron_1', 'pron_2', 'uzb', 'uzb_1', 'uzb_2';). You need to change *id*, after values. I hope I was able to explain.

I am writing an application that should work with the database. I create a database through SQLiteStudio, fill it, but how to ... ng database. I started programming for Android recently, so I'm interested in the right approach to the solution this task.

Please tell me how to combine Entity Framework and SQLite? I put SQLite in the project already through Nuget. I created the m ... gh by the way, the DB file is created in the folder with the program, but it is 0 bytes, well, plus the error is still there.