A popular open-source embeddable (i.e. non client-server) RDBMS implemented as a C library.
-1
votes
2answers
59 views
checking number of occupied occupied neighbours [closed]
Assuming a pixel grid with x and y of the size 1000 over 1000. In each iteration\run, using a random number generator, certain cells will be marked as occupied. Those cells will be written in a SQLite ...
0
votes
1answer
25 views
How to use CREATE TABLE … AS with Primary Key in SQLite
From SQLite documentation for CREATE TABLE http://www.sqlite.org/lang_createtable.html:
A table created using CREATE TABLE AS has no PRIMARY KEY and no
constraints of any kind.
So is there any ...
0
votes
1answer
27 views
How to properly format sqlite shell output?
If I go to mysql shell and type SELECT * FROM users I get -
+--------+----------------+---------------------------------+----------+-----------+--------------------+--------------------+
| USERID | ...
1
vote
1answer
30 views
Database design: nested tagging
I have a situation that after an initial thought ended in the following tables:
section: id, name
section_tag: id, name
section_tag_map: section_id, tag_id
item: id, name
...
1
vote
1answer
36 views
Referencing multiple tables from a single table and store additional data
I have a database where I want to store lap time information from a racing game. I have tables for car, track, game, tuning and upgrade data and want to put all these together to create a single ...
-1
votes
0answers
23 views
Joining two columns value in 1 table and sort it in ascending Using SQLITE [closed]
I have two kind of discount
1.the fixed php
2.the percent %
they are different columns in just the same table
the table name is discount,
the table column is disc_amt, disc_pct
the name of ...
2
votes
1answer
47 views
Read-only on an SQLite database which is being modified by another program
I wrote a program that has an SQLite database, modifying it every few seconds.
Now I want to write a small gadget program that would just read a bit of info from that database (read-only) and display ...
-1
votes
1answer
70 views
How to create view in SQLite using INSERT INTO? [closed]
I'm trying to create view that will summarize data in two tables. Each table have several columns, but they both have NAME and AREA columns. And I want these two columns to be united correspondingly ...
1
vote
1answer
45 views
SQLite writing a query where you select only rows nearest to the hour
I've got a set of data where data has been taken approximately every minute for about three month and the time has been stored as a unix timestamp. There is no regularity to the timestamp (i.e. the ...
0
votes
0answers
61 views
Constructing an SQL query with time intervals
I've a simple but large table in an SQL database which has four fields (id(int PK), time (unix timestamp, not null), value (double, not null) and an ID_fk (integer foreign key).
Data is recorded ...
1
vote
1answer
46 views
Query to find Maximum friends not giving correct resuts
Table Schema
Likes table
id,id1
1,2
1,3
2,1
I have count of total number of Likes for each student through this
select id,count(*)
from friends
group by id
Now I have to find ...
1
vote
0answers
49 views
Regular Expression Integrity Constraints in SQLite3
In a SQLite3 CREATE TABLE statement, can I use a regular expression to enforce a particular constraint? Specifically, I am trying to require that an inputted URL is valid. I know there are other ways ...
0
votes
1answer
64 views
Delete with subquery with no unique columns
I have a table LIKES (ID1, ID2). Both id1 and id2 are non unique columns.
Database is SQLite
delete from LIKES where ID1 = 10 /// Wrong there more then one record with ID1=10
delete from LIKES ...
1
vote
1answer
62 views
Configuration options for relational algebra evaluator “ra.jar”
I am participating in the Stanford Database Class, and there are some problem sets to be solved in "mathy" relational algebra syntax.
The course instructors demand from students to use this ...
0
votes
0answers
184 views
How to integrate sqlite extension in XAMPP?
There's an extension on the http://www.sqlite.org/contrib?orderby=date, extension-functions.c, which integrates the SQRT command in sqlite.
How can I integrate this and use it in my Windows-XAMPP ...
