Question : Currently we (an active opensource project) have a large PostgreSQL production database which contains all the site records. […]
Tag: sqlite
How can this query be improved to be faster?
Question : I am trying to make a search in a db which contains tables poems and authors. I am […]
How to denormalize many-to-many relation without nested select?
Question : I have the following schema: house has many students, student has one house gender has many students, student […]
Which database should I look at for analyzing ~30gb, 700M records dataset?
Question : I’m looking at analyzing a kaggle dataset which is pretty normalized, specifically joining, grouping, slicing and dicing the […]
MySql data export to import in sqlite [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Database design for mobile app
Question : At first I would like to say hello to all of you, since it is my first post […]
How to optimize search restricted by boolean column?
Question : I want to optimize a query1 of the form SELECT yid, xid FROM x WHERE is_principal; Here, is_principal […]
SQLite how to store translations
Question : Im looking for advise because my experience is not really good in SQLite. My table look like this: […]
What is the best way to store product size and color for an Ecommerce database?
Question : I am trying to find the best way to store product size, colour for an sports store website, […]
When do I use another type index than integer? (eg string) [integer vs string index]
Question : I was reading about relational databases like sqlite and I always see the schema for user storage like: […]