New answers tagged

1 vote
Accepted

How Whatsapp Search/Index Encrypted Chats specially IndexedDB, Searchable Encryption

Most apps would only encrypt the data at rest when it is in a file, or when it is in transit over a network. To work with data in memory (as with a search) the data must be decrypted first. With ...
pmdba's user avatar
  • 3,104
0 votes

Create an affiliate system (also known as a referral program like Rewardful, Tapfiliate) in SQLite?

Too convoluted. There is an easy (kinda) approach to DB design. Draw your table with all the fields and data you need or can think of in a single Excel spreadsheet. Once you know that you can find ...
White Owl's user avatar
  • 797
0 votes

Alternative to multi-master replication between local and cloud db when writes are infrequent and only 1 db at a time

If you guarantee that there is only one user at a time despite several devices going to the same database, then the easiest way would be to just copy database file. You will have some file-sharing ...
White Owl's user avatar
  • 797
1 vote

SQLite: How to include an Sqlean define statement in a `.sql` file?

Answering my own question. According to @nbk user, UDF are not part of the database, but of the session. Fortunately, SQLite offers a .read command which can execute a SQL file. So, under the SQLite ...
Aristide's user avatar
  • 121

Top 50 recent answers are included