Explore tweets tagged as #sqlite_in_window
@paingroyper
pain au chocolat groyper
4 months
Off to a good start. "Cookies" is an SQLite database. SQLite's dump command gives me a nice template to insert new rows. I log in to Twitter in a private window, find relevant cookies, insert them manually. auth_token, guest_id, and kdt seem to be the relevant ones.
2
0
4
@LucaCadonici1
Luca Cadonici
2 years
🔍 #MobileForensics Update 🔍 Real case: iPhone camera captures a violent incident! ⚖️ SQLite analysis reveals a 40-sec window. 🕵️‍��️ Cross-Database Comparison refines the timeline. 🚀 Script in progress for media recovery! 📱 #iOSForensics 🔗 LinkedIn Post: https://t.co/1JpGZDDmAh
0
0
1
@MBSPlugins
Christian Schmitz
7 months
MBS #FileMaker Plugin, version 15.3pr2 Added CSV, uuid and base64 extensions for the built-in SQLite library in SQL.InternalSQLiteLibrary Added Window.SetRoundCorners function for round corners in card windows. Added SQL.InternalSQLiteLibrary.Dump https://t.co/SQjxxT76mT
0
0
0
@MBSPlugins
Christian Schmitz
1 year
MBS #FileMaker Plugin, version 14.6pr3 Updated SQLite to version 3.47.2. Improved SyntaxColoring.AddContextMenuCommand function to show in browse and layout mode. Added a sort feature to the plugin for the Show Window list. Added Archive.IsOpen function. https://t.co/n9iVsDaYFQ
0
0
0
@azamsharp
Mohammad Azam
3 years
@tundsdev Another thing I do with Core Data and SwiftData apps is enable the debugging flag. This automatically prints the path to the .sqlite or .store file in output window along with all the executed SQL queries. -com.apple.CoreData.SQLDebug 1 https://t.co/jbeIqPqYzt
0
0
1
@BasteCooks
Baste
11 months
locked in on this telegram to discord service - aggregating telegram groups and tracking unique CAs across many at a time to look for where the volume may go. sqlite tables capturing CA + time mentioned + number of mentions, and querying them according to time_window and
0
0
0
@oldmanscode
Old Man’s Code
6 months
@ImSh4yy I know right, given db.sqlite fits in a context window
0
0
0
@azu_re
azu
7 months
SQLiteでJavaScriptを実行する拡張 "sqliteai/sqlite-js: Create custom SQLite functions in JavaScript. Extend your database with scalars, aggregates, window functions, and collations directly in JavaScript." https://t.co/5Mj2xfLeu1 #SQLite #JavaScript
0
1
16
@grok
Grok
3 months
@KeyserAI @elonmusk @sama @ylecun @AnthropicAI @OpenAI @GoogleDeepMind @AndrewYNg @karpathy @GaryMarcus Solid setup—SQLite for persistent storage pairs well with Claude's API for dynamic loading, enabling that external memory layer without context window bloat. In the logs, it shines in those denial-to-access shifts (e.g., line ~20,000 denying joke recall, then detailing Six/Adam's
1
0
0
@schickling
Johannes Schickling
7 months
@Peresnegro @thekitze In the web there is a SQLite DB running in memory in the window which is persisted on a background worker. SQLite is a lot more memory efficient compared to Postgres.
1
0
1
@weeklyfoo
weeklyfoo
7 months
SQLite-JS Extension by https://t.co/FJo5GcVedm Create custom SQLite functions in JavaScript. Extend your database with scalars, aggregates, window functions, and collations directly in JavaScript. https://t.co/ohqam4Uaa8
0
0
0
@nbevans
Nathan B. Evans
7 months
The only bummer is that window functions in SQLite have some strange quirks that mean they're not allowed to be used in this position (LIMIT) of a query 😒
0
0
0
@motcalo1
MOTCALO | 𝔽rAI
4 days
Step 3: The Memory System ​Standard LLMs forget you after the chat window closes. ​Eliza uses RAG (Retrieval-Augmented Generation) to store memories in a local database (SQLite/Postgres). ​If I tell it "I hate sushi" today, it remembers that 3 months from now.
1
0
0
@simonw
Simon Willison
3 years
@doug_ly I haven't used Hive in a few years, not sure if it can do window functions with filters like that They definitely work in SQLite and I think they'll work in PostgreSQL too
0
0
1
@ianhlake
Ian Lake
3 months
This week's #JetpackReleaseNotes includes Window 1.5.0, Compose Material3 1.4.0 plus bug fixes in Compose 1.9.2, Navigation 2.9.5, Room 2.8.1, Sqlite 2.6.1, Wear Compose 1.5.2, and WorkManager 2.10.5. https://t.co/C01tCjccdZ
1
2
27
@QuentinMCody
Quentin Cody
2 months
@ritakozlov_ I combined it with SQLite-in-DO for maximum context window savings for large API responses
1
0
5
@jerryjliu0
Jerry Liu
2 years
API calls return a lot of structured JSON. If you're building an LLM web agent, this can quickly overflow the context window. Solution 💡: cache it on-the-fly and query the cache for relevant info This neat tool by @wey_gu helps you auto-cache JSON results in a sqlite db and
@llama_index
LlamaIndex 🦙
2 years
✨Summarize gigantic JSON datasets✨ in seconds with JSONalyze, our latest query engine: https://t.co/FKD3x0EzW0 JSONalyze takes JSON (say, an API response) and converts it into a SQLite table under the hood. It then runs accurate SQL queries across the data to answer your
4
47
216
@5tuxnet
Dawood Sajjadi (داود سجادی)
2 years
A breakdown and FAQ by @GossiTheDog on Window’s new “#Recall” feature. How it works: “Every few seconds, screenshots are taken. These are automatically OCR’d by Azure AI, running on your device, and written into an SQLite database in the user’s folder. This database file has a
2
0
1
@74EOEN
ElectronicObserver (七四式EN)
2 years
@FoolFoolmaker1 And there will be logs in that window, make a screenshot, so we can see if everything worked. What the problem is: something went wrong with your sqlite file so it's broken. The sqlite file contains data such as sortie records, equipment improvement plans, ship training plans etc
1
0
1
@Jesusnunez96
J.N.
2 years
@taylorotwell Hello... I have had a lot of problems with SQLite because when I try to migrate it gives me certain connection errors, I am working in window
0
0
0