phpdesktop VS sqlitebrowser

I am a bit surprised by the critical tone in the comments here. Phpdesktop [1] is, for example, a very nice application, and the ability of php to just make some simple scripts on the go and have something that works, is wonderful (compared to js where you often have to build etc, the threshold of getting started on a new computer is high). I have several times needed to make simple applications with a database, and php is perfect for that usecase. Making it simpler to share these applications to non-technical users for offline use is nice

[1] https://github.com/cztomczak/phpdesktop

I’ve been using PHP Desktop for a while for internal tools. https://github.com/cztomczak/phpdesktop

There's a project to make php apps -- https://github.com/cztomczak/phpdesktop -- but it doesn't have Mac support yet. Alas.

Since we're in the webdev subreddit, I suppose you will use a webstack. Here is what I have been using in an institution with a hellish ton of xp computers: PHPDesktop ChromeV47 . PHP is not mandatory, since it basically searches for and index.* file, which can be a html file with a lot of js. Use jquery with ajax calls to make your life easier for API requests and other stuff of old era JS (I dont remember if it supports fetch api and newish QOL changes). You basically develop a web app in a chrome wrapper. Works just fine on oldies.

re-write it as a desktop app, you could use php desktop to save time.

PHP Desktop seems to use 7.2.12, which reached end of life on late 2020. I wouldn't put my eggs in that basket.

Ever since I found PHP desktop (https://github.com/cztomczak/phpdesktop), I've been having a blast playing around with it. I've created my own "desktop applications" that I use daily. It's quick to build something I need to run locally (on Windows) vs learning/building an actual Windows application. Also I find PHP easier to build MVPs over Javascript (i.e. Electron). I'm curious if anybody else is building anything using PHP desktop? What kind of applications/services did you build or using with it?

Go to this repo https://github.com/cztomczak/phpdesktop by Czarek Tomczak, then search for downloads. As I’m working with Windows, I used PHP Desktop v57.0 for Windows release (https://github.com/cztomczak/phpdesktop/releases/tag/chrome-v57.0-rc). Download the zip file and extract the content wherever you want. Rename the folder as you prefer, you could use the name of your website. Let’s call it Myapp. This is a sort of container with a self-contained web server (Mongoose) and PHP 7.1.3. For example, launching the exe file called phpdesktop-chrome.exe will “read” what’s inside the Myapp/www folder. That’s where you will have to move your entire website to.

There's also phpdesktop which is akin to Electron and other such things.

We have a spread of different GitHub Actions based workflows that do stuff whenever a PR is proposed or merged:

https://github.com/sqlitebrowser/sqlitebrowser/tree/master/....

Most of those are oriented around building packages for various OS's (Linux, macOS, Windows) so people can try the latest code.

While there are some tests, they're more like extremely basic sanity tests and don't rely on Docker.

Those tests rely on whichever version of SQLite was downloaded and compiled into the GUI (as per above code snippet).

---

That being said, that's for the client side GUI application. There's a server side of things too (https://github.com/sqlitebrowser/dbhub.io -> dbhub.io) that does use docker for it's automated tests:

https://github.com/sqlitebrowser/dbhub.io/tree/master/.githu...

Those are integration tests though (eg "make sure we didn't bust communication with our cli", "make sure our go library still works 100% with the server"), and a reasonably decent set of End to End (E2E) tests of the web interface using Cypress.

---

Does that help? :)

Do you know about SQLite DB Browser ? It's a multi platform application that would perfectly fit your use case :).

https://sqlitebrowser.org/

Someone gave you a sqlite database. You probably started to think to install a program like sqlitebrowser, but only to view and read the data. Don't bother, you can use this extension instead.

Try https://sqlitebrowser.org/ it’s great for local use and training purposes

You can see how the db file looks for the app using https://sqlitebrowser.org/

If you want to fiddle with SQLite and don't need all the power herein, I recommend DB Browser for SQLite.

https://sqlitebrowser.org/

Hello y'all. This is my first post here. I'm learning SQL with the Northwind database. When I run a "big" query, like "SELECT * FROM Customers" the application crashes. I noticed this only happens when I run a general query, for example, if I run something more specific (and, by the hand "smaller") it doesn't happen. So, I thought it could be related to the size of the query. But I'm a total beginner so idk. It doesn't happen every time I try to use it, but still, this is frustrating. If there's no solution, what other SQL application can I use to keep learning? I found something on GitHub but this is for an older macOS version.