kivy VS sqlx

We will create this complete Python registration form using Kivy. We get started by installing Kivy, a powerful Python framework for building interactive applications.

For reference, YouTube runs on Python[1,2,3]:

> 1. Python and Django: YouTube’s backend is predominantly written in Python, offering a balance of performance and readability.

> 2. Google Cloud Platform...

> 3. Java and C++: YouTube also utilizes Java and C++ for specific backend services, as they provide better performance for certain tasks.

---

A long time ago, I looked into these Python frameworks:

- http://www.web2py.com/

- https://kivy.org/

[1]: https://blogopost.com/youtube-tech-stack/#backend

[2]: https://medium.com/@shanthanaroja99/technology-stack-behind-...

[3]: https://youtu.be/G-lGCC4KKok

I have a multi-threaded app using Kivy for the GUI and sometimes need to update the GUI from a background thread. This app is a few years old and I recently updated to Kivy 2.2 and am now getting an exception with the message "Cannot create graphics instruction outside the main Kivy thread" -- which is related to this change in Kivy 2.1: https://github.com/kivy/kivy/pull/7270

I suggest you use kivy which is suitable for the desktop but also has the advantage of being one of few options for creating Python based native(ish) mobile apps (for IoS and Android app stores).

I think the best one right now for python is "beeware": https://beeware.org/

You also have Kivy which is prety good: https://kivy.org/

Anyone has some experience with Kivy [1]? It seems that it checks off some of my requirements, like cross-platform, supporting touch interfaces, ease of development, allows complex/fancy UIs as well, etc.

[1] https://kivy.org/

There are hot reload tools like kivy.tools.kviewer and KivyMD HotReload and I think others... but maybe they used something else, hard to tell

Notable Projects: Kivy ( https://kivy.org/ )

My name is Mathieu Virbel, and I am a consultant on system and software architecture with over 12 years of experience as a freelance and 20 years in the field. I have a passion for creating innovative and user-friendly applications. I specialize in using the open-source Kivy framework to develop desktop and mobile applications, but I am also skilled in other technologies and frameworks.

SEEKING WORK | France (UTC-1) | Remote | Full stack developer

My name is Mathieu Virbel, and I am a consultant on system and software architecture with over 12 years of experience as a freelance and 20 years in the field. I have a passion for creating innovative and user-friendly applications. I specialize in using the open-source Kivy framework to develop desktop and mobile applications, but I am also skilled in other technologies and frameworks.

I worked on a variety of subjects, from Interactives and mobile application for Museum and Public Institutions, Embedded system in security company, telecommunication, and Startups environments from scratch. Recently playing with Python, Golang, VueJS 3/Typescript, InfluxDB, Docker Swarm, as well as writing specifications and reviewing code of others contractors.

Technologies: Python (django, flask, tensorflow, Kivy, …), Golang, TypeScript, VueJS, Quasar, Docker, Docker Swarm, Terraform, Ansible, MongoDB, InfluxDB, MariaDB, SQLite, Kafka, Prometheus/Graphana

Résumé/CV: https://meltingrocks.com/cv

LinkedIn: https://www.linkedin.com/in/mathieuvirbel/

Website: https://meltingrocks.com

Email: [email protected]

Notable Projects: Kivy ( https://kivy.org/ )

We've always used https://github.com/jmoiron/sqlx which is just the standard package + mapping to/from structs.

You can use this https://github.com/jmoiron/sqlx

I will be using sqlx to execute queries and map columns to struct fields and vice versa, sqlx is a library which provides a set of extensions on go's standard database/sql library.

sqlx + squirrel ftw

I'd rather suggest the use of tools more aligned with the core concepts of the language such as sqlx, which is an extension of the database/sql standard library. It allows you to use models/structs to map your tables but you have more control over the SQL statements you use to perform queries and the like. You can combine sqlx with Squirrel to build queries from composable parts.

IDE: use whatever make you productive. I personally use vscode. VCS: git, as golang communities use github heavily as base for many libraries. AFAIK Linter: use staticcheck for linting as it looks like mostly used linting tool in go, supported by many also. In Vscode it will be recommended once you install go plugin. Libraries/Framework: actually the standard libraries already included many things you need, decent enough for your day-to-day development cycles(e.g. `net/http`). But here are things for extra: - Struct fields validator: validator - Http server lib: chi router , httprouter , fasthttp (for non standard http implementations, but fast) - Web Framework: echo , gin , fiber , beego , etc - Http client lib: most already covered by stdlib(net/http), so you rarely need extra lib for this, but if you really need some are: resty - CLI: cobra - Config: godotenv , viper - DB Drivers: sqlx , postgre , sqlite , mysql - nosql: redis , mongodb , elasticsearch - ORM: gorm , entgo , sqlc(codegen) - JS Transpiler: gopherjs - GUI: fyne - grpc: grpc - logging: zerolog - test: testify , gomock , dockertest - and many others you can find here

This is the same situation I saw 20 years ago. Back then, all the managers were pushing development in Oracle tools. Those managers grew up on Oracle and Java was too modern for them. Now the situation is similar. Managers used to do things in Java and now they are still pushing Java. In fact, today Java brings nothing but problems. When I see a new project starting on Java it is always some big desperation. For a comparison of Java and Go, just look at the documentation for SQL. For go: https://pkg.go.dev/database/sql (31 pages) and maybe https://jmoiron.github.io/sqlx/ (12 pages). In Java only one class is 59 pages (https://docs.oracle.com/javase/8/docs/api/java/sql/ResultSet.html) and look how many of those documents there are: https://docs.oracle.com/en/java/javase/13/docs/api/java.sql/java/sql/package-summary.html and on top of that we have javax.sql - https://docs.oracle.com/javase/8/docs/api/javax/sql/package-summary.html And even then you use Hibernate for example, where the documentation has 11 manuals and of those the User Guide has 353 pages - https://docs.jboss.org/hibernate/orm/6.2/userguide/html\_single/Hibernate\_User\_Guide.html

sqlx