Recently, I deployed a Go-powered app backed by an SQLite database on Fly.io for the first time. From start to finish, It took about four days of reading, configuring, experimenting, and (more than a little) frustration; mostly because the app was backed by an SQLite, flat-file, database instead of a client/server database. Here’s the process that I went through, along with some of the issues that I encountered along the way. 👇 https://lnkd.in/gya2pStZ Deployment icon by Freepik, available on Flaticons: of https://lnkd.in/gHr8Fvs3
Matthew Setter’s Post
More Relevant Posts
-
This will generate QR code for you from any type of text, regardless of language or format. ( works with links also 🔗 ) Github Pages ( Live 🟢 ): http://niloykm.me/qrCode/ Github repository ( Source Code ): https://lnkd.in/gpX5m3A8 Technical Explanation: This app uses an API to send text and receive the corresponding QR code image.
To view or add a comment, sign in
-
TIL all your iMessages are stored in a SQLite db in ~/Library/Messages/chat.db which you can easily query! Average number of daily messages you’ve sent in 2024: sqlite3 ~/Library/Messages/chat.db "SELECT ROUND(COUNT(*) * 1.0 / (julianday('now') - julianday('2024-01-01')), 1) FROM message WHERE is_from_me = 1 AND datetime(date/1000000000 + strftime('%s','2001-01-01'), 'unixepoch') >= datetime('2024-01-01');" PS: Make sure to give your terminal app full disk access first
To view or add a comment, sign in
-
Want to compile #Rust code on #iOS📱? Follow these easy steps: 1) Install iSH from the App Store. 2) Open iSH and run the following commands: $ echo https://dl-cdn[.]alpinelinux[.]org/alpine/v3.16/main > /etc/apk/repositories $ echo https://dl-cdn[.]alpinelinux[.]org/alpine/v3.16/community >> /etc/apk/repositories (remove [ ]) 3) Install the cargo: $ apk add cargo 4) Create a new Rust project: $ cargo new hello_world ✅ (Optional) insert the commands from step 2 into ~/.startup/apk_rep.sh so they run each time you start iSH. because Every time you enter, the repository links revert to the default ones for iSH, which causes many issues. ‼️The app has some bugs, but you can work around them. ⚠️ One known issue is with copy-pasting and closing the keyboard: if you encounter problems, just tap the settings button once and exit to make the keyboard close and paste buttons work again! enjoy rusty 🦀 #rustlang #iSH
To view or add a comment, sign in
-
Day 16 - Continued backend: Learned how the database server interacts with the backend server. - Finished the customer review app: You can now use this URL: …https://lnkd.in/gRdW5UMv as a script tag to add a popup to your site. Now, onto the frontend! #100DaysOfCode
To view or add a comment, sign in
-
Exciting news! 🚀 I'm thrilled to announce the launch of my new project: To-Do List app built with Flutter and powered by SQLite database integration. 🎉 With this app, you can organize your tasks efficiently. Features: • Mark the task as completed • Add new task • Update the wrongly entered task • Delete the task 🔗Github link: https://lnkd.in/gqHv7PmP #Flutter #MobileAppDevelopment #SQLite
To view or add a comment, sign in
-
How to set up Drizzle ORM with Next.js App Router | Server Actions Learn by building a project https://lnkd.in/dXF34Bdj
To view or add a comment, sign in
-
For every app that I create, I find myself adding authentication over and over again. It got repetitive and boring. To solve this, I created this template that adds auth to a Remix application, hosted on Cloudflare Pages. It uses D1 as the database and Prisma ORM. Hope it helps you get started with your next app idea, quickly! https://lnkd.in/d4TJsVB3
To view or add a comment, sign in
-
My new project; a simple invoice app using flask and SQLite. So, a dear friend of mine wanted to standardize their invoice. There are many examples on the web, but not that many that have a built-in database for the clients and services. What I've implemented is a simple local SQLite database with clients and services that has a straightforward interface for an average user using flask framework. If you have created a client with their details, and any service or product, you can make an invoice based on their purchase. Feel free to check the repo, I just built yesterday. Just pull request for any feature. Link to github repo: https://lnkd.in/gxRC4Jm2
GitHub - farahanasuhaimi/invoice_app: This is a simple invoice app that allows you to create, read, update and delete invoices. It is built using Flask and SQLite database.
github.com
To view or add a comment, sign in
-
Day 128 of 100. Today, I successfully integrated Room Database into my app 🎉. Gradle was kind to me this time, running without any hiccups. Setting up the Room database, ViewModel, and ViewModelFactory came with a few challenges, but nothing I couldn't tackle. Now, orders added to the cart are saved locally in the database. Looking ahead, I plan to sync the data with Firebase Realtime Database to enable online synchronization. On another note, I saw a post on X appreciating apps with Google authentication, and it got me thinking. I’ve never implemented Google Auth before, but it seems like a great feature to add for smoother user login and a chance to learn something new. I also made progress on the BottomBar: ✅ The Home button now leads to the MainActivity. ✅ The Cart button navigates to the CartActivity. ⚡ For now, the Mail and Profile buttons only change color when clicked—but I'll expand their functionality soon. The app’s performance is a bit laggy, likely due to my current system and some unoptimized code. A cleanup is definitely on the agenda to make the app smoother and more efficient. #AndroidDev #Kotlin #1000daysofcoding #mobiledev
To view or add a comment, sign in
-
I recently explored using SwiftData to store API responses in my new project, Fetcher. It's a SwiftUI app that lets you manage user data with filtering, sorting, and deletion options. If you're an iOS developer interested in SwiftData, check out Fetcher and see how I implemented data persistence! It's a great way to learn and experiment. https://lnkd.in/gQuUfAga
GitHub - kevveth/Fetcher: This project focuses on decoding JSON from the internet and displaying some of that information on an iOS device, in a user-friendly manner.
github.com
To view or add a comment, sign in