shareshortcuts
110 subscribers
3.72K photos
36.4K links
Download Telegram
Tables, joins, encryption and backups on your iPhone. No app to install. No server. No account. Your data never leaves your iCloud Drive.At a glanceReal SQLJOIN, GROUP BY, subqueries, UNION, transactions and 60+ functionsEncrypted databasesAES-256-GCM with a key only you know. Change it or turn it on any timePrivate databasesHidden from the console, for the shortcut that owns themBackup & restoreEvery database in one .ssql file. Move to a new iPhone in secondsHistoryYour last 20 queries, one tap to run againBeautiful resultsA clean table page in light or dark, or plain textDeveloper APIOne Run Shortcut action gives your shortcut a databaseFully offlineEverything runs on the device. Internet is only used to tell you about updatesHow it worksRun ShortSQL. That's the whole setup.
id INT PRIMARY KEY AUTO_INCREMENT,
item VARCHAR(80) NOT NULL,
amount DECIMAL(10,2) NOT NULL,
tag TEXT DEFAULT 'other',
spent DATE DEFAULT (CURRENT_DATE)
);
-- Where did my money go this month?
SELECT tag, COUNT(*) AS times, SUM(amount) AS total
FROM expenses
WHERE spent >= DATE_FORMAT(CURDATE(), '%Y-%m-01')
GROUP BY tag
ORDER BY total DESC;
Everything that's supportedDatabases: CREATE (plain, ENCRYPTED, PRIVATE), ALTER DATABASE … KEY / DECRYPT / PRIVATE / PUBLIC, SHOW DATABASES, DROPTables: CREATE (incl. AS SELECT and LIKE), ALTER (add, drop, rename, modify, change columns, rename table), DROP, TRUNCATE, RENAME, DESCRIBE, SHOW TABLES, SHOW CREATE TABLE, SHOW INDEXWriting: INSERT (multi-row, SELECT, SET), INSERT IGNORE, REPLACE, ON DUPLICATE KEY UPDATE, UPDATE and DELETE with ORDER BY / LIMITReading: JOIN, LEFT / RIGHT / CROSS JOIN, GROUP BY, HAVING, DISTINCT, ORDER BY, LIMIT / OFFSET, subqueries (IN, EXISTS, scalar, derived tables), UNION / UNION ALLExpressions: CASE, CAST, BETWEEN, LIKE, REGEXP, IS NULL, <=>, DIV, MOD, INTERVALConstraints: PRIMARY KEY, AUTO_INCREMENT, UNIQUE, NOT NULL, DEFAULTTransactions: BEGIN / COMMIT / ROLLBACK; any ; script is saved only if every statement succeedsFunctions: text (CONCAT, SUBSTRING, REPLACE, LPAD…), numbers (ROUND, ABS, POWER…), dates (NOW, DATE_ADD, DATEDIFF, DATE_FORMAT…), logic (IF, IFNULL, COALESCE…), totals (COUNT, SUM, AVG, MIN, MAX, GROUP_CONCAT)Simple SELECT, COUNT, UPDATE and DELETE run as a few native actions, so big tables stay quick.Your data, locked downCREATE DATABASE vault ENCRYPTED encrypts every table with AES-256-GCM. The key is stretched with PBKDF2 (100,000 rounds), so guessing it is slow.Change your mind later: ALTER DATABASE vault KEY 'new key' re-encrypts everything. It works on unencrypted databases too.PRIVATE databases never show up in the console list.Everything lives in iCloud Drive › Shortcuts › ShortSQL. Nothing is uploaded, ever.Note: a lost key cannot be recovered. That's what makes it encryption.Never lose a thingMenu › Backup & restore saves one database, or all of them, into a single .ssql file. Keep it in Files, AirDrop it to a new iPhone, restore it there. Encrypted databases stay encrypted inside the backup.For shortcut developersStop juggling text files. Give your shortcut a real database in three actions:Text with a JSON request (or a Dictionary)Run Shortcut → ShortSQLGet Dictionary from Input → read rows, affected or error{
"db": "myapp",
"query": "SELECT id, title FROM notes WHERE done = ?",
"params": [0]
}
Reply:{
"ok": true,
"count": 2,
"rows": [
{ "id": "1", "title": "Buy milk" },
{ "id": "2", "title": "Call mom" }
]
}
Bulk insert: many rows, one call, all or nothing:{
"db": "myapp",
"table": "notes",
"rows": [
{ "title": "Buy milk" },
{ "title": "Call mom", "done": 1 }
]
}
FielddbrequiredDatabase namequeryrequired*One statement, or a ; script that saves all or nothingparamsoptionalA value for each ?, quoted safely: quotes, emoji, line breakskeyoptionalFor encrypted databasestable + rowsoptionalBulk insert, instead of a querycheck_updatesoptionalfalse keeps your shortcut 100% offlineReplyoktrue, or false with an error messagerows · countAfter a SELECTaffected · insert_idAfter INSERT, UPDATE, DELETEShortSQL Starter · View in Editor: install it from Menu › Developers for copy-ready blocks (setup, insert, select, update, bulk insert, encryption, private databases). The complete API guide is built into the console too.Ideas to buildNotes and to-do apps with search, tags and due datesExpense and habit trackers with monthly totalsInventory, collections and reading listsSettings storage for your own shortcuts: INSERT … ON DUPLICATE KEY UPDATELogs from automations, queried later with GROUP BYFAQDo I need the internet?
No. Everything runs on your iPhone. When you happen to be online, ShortSQL checks once in a while for a new version.Will updating delete my data?
Never. Your databases live in iCloud Drive, not inside the shortcut.Can other people's shortcuts read my databases?
Any shortcut you run can call ShortSQL. That's how the API works. Use ENCRYPTED for anything sensitive: without the key, the data is unreadable.What isn't supported?
Users and GRANT, views, triggers and stored procedures. It's a personal database with one request at a time, not a server.Does the name matter?
Yes. Keep it named ShortSQL exactly, so other shortcuts can find it.Support & communityDiscord (https://discord.gg/sS5Wqa4TNp)Chat, updates, bug fixes and weekend funTelegram (https://t.me/ios_shortcuts)Updates and bug fixes, straight to youShortSQL · Developed by Anup
A Day with the iPhone Duo: First Impressions
https://www.macstories.net/stories/a-day-with-the-iphone-duo-first-impressions/

I spent Wednesday in New York, interviewing developers about their iPhone Duo apps. It was like a little slice of WWDC dropped among Manhattan’s skyscrapers, which was wonderful. There’s nothing I enjoy about what we do at MacStories more than talking to developers about their apps and the stories behind them. I left the city […]
Apple Investigating Options for Extending Web Content Under iPhone Duo’s Safari Controls
https://www.macstories.net/linked/apple-investigating-options-for-extending-web-content-under-iphone-duos-safari-controls/

Jen Simmons, writing at the official WebKit blog: Safari 27.1 does bring one change to users. Now, when someone holds iPhone Duo partially folded like a book while looking at a PDF on the web, Safari 27.1 automatically shows PDFs as two pages side by side. When they open the screen flat or close it […]
MacStories Weekly: Issue 534
https://www.macstories.net/club/macstories-weekly-issue-534/

This week, in addition to the usual links, app debuts, and recap of MacStories' articles and podcasts:Trying to Get Work Done on the iPhone Duo, by Federico (https://www.macstories.net/club/macstories-weekly-issue-534/#trying-to-get-work-done-on-the-iphone-duo)14 iPhone Duo Tips, Tricks, and Little Details, by John (https://www.macstories.net/club/macstories-weekly-issue-534/#14-iphone-duo-tips-tricks-and-little-details)Duo Questions, Dictation Dilemmas, and DIY Fixes, by John (https://www.macstories.net/club/macstories-weekly-issue-534/#duo-questions-dictation-dilemmas-and-diy-fixes)

This Story is for Club Members

Get weekly newsletters, exclusive stories, member downloads, and ad-free version of MacStories Unwind.

See Plans (https://www.macstories.net/plans?utm_source=ms&utm_medium=web)

 

Already a member? Sign in (https://www.macstories.net/?memberful_endpoint=auth)
rawafd
https://shareshortcuts.com/shortcuts/4328-rawafd.html

رَوافِد هو تطبيق يحتوي على العديد من القصص للأطفال  لإضافة قصةالقواعدقصص عربية فقطلا قصص رعبقصص للأطفال فقط ٣-١١ سنوات
Ransom
https://shareshortcuts.com/shortcuts/4330-ransom.html

Ransom from doors
Also it’s not really ransom it’s a-90 and locks you out of your phone for no reason
<!-- SC_OFF -->I don’t love the tracking that gets added to a URL when using the share button in most apps (yes, even just “Copy Link”) so I made a simple Shortcut that scrubs the tracking from a given URL. Here’s a link to this Shortcut (https://www.icloud.com/shortcuts/f0c38e404d4f47eba275a9738a1f8525) if you’d like to try it for yourself. This post and Shortcut were made without the use of AI. Edit to Add: does not currently work with YouTube, working on a fix now. <!-- SC_ON --> submitted by /u/Quartziferous (https://www.reddit.com/user/Quartziferous)
[link] (https://i.redd.it/okqoqzv385xh1.jpeg) [comments] (https://www.reddit.com/r/shortcuts/comments/1xd44l3/antitracking_share_sheet/)
<!-- SC_OFF -->Hi all, I have a dedicated iPad for all things D&D and I’ve always used the shortcuts app to function as a soundboard. After updating to iOS 27, the buttons now bring up the configuration and I have to instead press the tiny play button at the top right. This is quite inconvenient for what I use it for, does anyone know if there’s a way to swap it back? <!-- SC_ON --> submitted by /u/Reasonable-Maize1129 (https://www.reddit.com/user/Reasonable-Maize1129)
[link] (https://i.redd.it/u4d25flj76xh1.jpeg) [comments] (https://www.reddit.com/r/shortcuts/comments/1xd7jm5/shortcuts_no_longer_function_as_buttons/)
iPhoto shortcut
https://www.reddit.com/r/shortcuts/comments/1xdnsdn/iphoto_shortcut/

<!-- SC_OFF -->All the posts I’ve seen about this are old so wondering if it’s possible now. I’m a clothing reseller and I’m looking for 2 shortcuts. Is there a shortcut to “auto enhance” and maybe resize (although less important) all the photos in a specific album. A shortcut to have google lens look up and find a stock photo/product name and price comps? (This one might be an ai agent task?) Any help would be greatly appreciated and I’d be happy to throw someone a couple bucks to either point me in the right direction or help me set this up. <!-- SC_ON --> submitted by /u/stevesparkle (https://www.reddit.com/user/stevesparkle)
[link] (https://www.reddit.com/r/shortcuts/comments/1xdnsdn/iphoto_shortcut/) [comments] (https://www.reddit.com/r/shortcuts/comments/1xdnsdn/iphoto_shortcut/)
Creating a shortcut that expands text (text expander replacement)
https://www.reddit.com/r/shortcuts/comments/1xdpvra/creating_a_shortcut_that_expands_text_text/

<!-- SC_OFF -->I use Text Expander on my Mac and it works fine- The issue is it really does not work worth a crap on my phone. Text expander allows me to have canned messages that include a subject line, body, and contain hypertext links to files. ( I have less than 10 of these tech support sorta stuff) I find that I have to send these quite often when I'm mobile, and it's a pain in the butt. - Text expander does not paste the HTML links in on iOS. And honestly, if I could figure out another way to do it, I would stop paying the annual fee to them. I've searched all over Stephen Robles' website, and I'm not finding anything. But I might be half blind. any help is appreciated ! <!-- SC_ON --> submitted by /u/papastvinatl (https://www.reddit.com/user/papastvinatl)
[link] (https://www.reddit.com/r/shortcuts/comments/1xdpvra/creating_a_shortcut_that_expands_text_text/) [comments] (https://www.reddit.com/r/shortcuts/comments/1xdpvra/creating_a_shortcut_that_expands_text_text/)
iPhone 16 Pro – Control Centre Shortcuts stopped working on iOS 26.5.2
https://www.reddit.com/r/shortcuts/comments/1xdux4o/iphone_16_pro_control_centre_shortcuts_stopped/

<!-- SC_OFF -->I'm experiencing a strange issue on my iPhone 16 Pro that started several days ago. All my custom shortcuts in Control Center suddenly stopped working, despite functioning perfectly before. Symptoms: Existing Control Center shortcuts show a loading animation but never execute. Adding a new "Run Shortcut" control doesn't work. Tapping "Choose" does absolutely nothing. Same issue when trying to select a shortcut for a Lock Screen control. All shortcuts work perfectly when executed directly from the Shortcuts app. Shortcuts assigned to the Action Button also work. What I've already tried: Removing and recreating Control Center controls. Creating a completely new, simple test shortcut. Force restarting the iPhone. Offloading and reinstalling Shortcuts. Updating iOS from 26.5.2 to 26.7.1. Nothing has worked. It seems like the system-level shortcut picker or the integration between Control Center and Shortcuts is broken. Has anyone experienced this recently? More importantly, has anyone found a solution that doesn't involve factory resetting the iPhone? I have quite a few shortcuts and automations, so I'd prefer to avoid anything that might delete them. <!-- SC_ON --> submitted by /u/Landomero (https://www.reddit.com/user/Landomero)
[link] (https://www.reddit.com/r/shortcuts/comments/1xdux4o/iphone_16_pro_control_centre_shortcuts_stopped/) [comments] (https://www.reddit.com/r/shortcuts/comments/1xdux4o/iphone_16_pro_control_centre_shortcuts_stopped/)
Benefits of 3rd party shortcut actions?
https://www.reddit.com/r/shortcuts/comments/1xdv5hc/benefits_of_3rd_party_shortcut_actions/

<!-- SC_OFF -->What app did you add that added beneficial action to your shortcuts. What were they and what was apples limitations it improved. Additionally, do you have any security concerns in using the 3rd party app? <!-- SC_ON --> submitted by /u/Monster1971 (https://www.reddit.com/user/Monster1971)
[link] (https://www.reddit.com/r/shortcuts/comments/1xdv5hc/benefits_of_3rd_party_shortcut_actions/) [comments] (https://www.reddit.com/r/shortcuts/comments/1xdv5hc/benefits_of_3rd_party_shortcut_actions/)
Made a Shortcut to Search and Save app icons in High Resolution directly to your device.
https://www.reddit.com/r/shortcuts/comments/1xe3rgq/made_a_shortcut_to_search_and_save_app_icons_in/

<!-- SC_OFF -->I made a shortcut called App Icon Downloader that lets you search for app icons from macOSicons.com (http://macosicons.com/) and download them directly to your Photos or Files. It uses the macOSicons.com (http://macosicons.com/) API to fetch icons, and you can choose the format you want to save them in. It has a nice vCard menu which let’s you see previews for the icons before downloading. You can either use the included public API keys or enter your own. Just keep in mind that the public keys might not always work, so using your own is an option if you run into issues. I’ve tried to keep the menus straightforward and the whole process quick. Thought I’d share it here in case anyone else finds it useful. RoutineHub: https://routinehub.co/shortcut/26906/ Let me know what you think or if there’s anything you’d improve. <!-- SC_ON --> submitted by /u/-pfg- (https://www.reddit.com/user/-pfg-)
[link] (https://www.reddit.com/r/shortcuts/comments/1xe3rgq/made_a_shortcut_to_search_and_save_app_icons_in/) [comments] (https://www.reddit.com/r/shortcuts/comments/1xe3rgq/made_a_shortcut_to_search_and_save_app_icons_in/)
I made a shortcut for downloading high-res app icons for free.
https://www.reddit.com/r/shortcuts/comments/1xe3wdb/i_made_a_shortcut_for_downloading_highres_app/

<!-- SC_OFF -->I’ve been working on a shortcut that makes it easier to find and save app icons without having to browse manually. It uses the site’s API to search for icons and displays the results in a vCard menu with previews, so you can see what you’re downloading before selecting it. You can save the icons to Photos or Files and choose your preferred supported format. It also supports using either a public API key or your own, although the public keys might not always work. I was wondering if anyone else here uses macOSicons.com (http://macosicons.com/) for custom app icons, and whether there are any features you’d find useful in a shortcut like this. If anyone wants to try it, here are the links: RoutineHub (https://routinehub.co/shortcut/26906/) Direct (https://www.icloud.com/shortcuts/6eb22583731a4bf894f19e701495b7c2) <!-- SC_ON --> submitted by /u/-pfg- (https://www.reddit.com/user/-pfg-)
[link] (https://www.reddit.com/r/shortcuts/comments/1xe3wdb/i_made_a_shortcut_for_downloading_highres_app/) [comments] (https://www.reddit.com/r/shortcuts/comments/1xe3wdb/i_made_a_shortcut_for_downloading_highres_app/)