RoSQL - SQL Client vs Learn Django 3 - DjangoDev PRO Usage & Stats
SQL Worksheet and Query Client for Oracle / MySQL and MSSQL Databases
IMPORTANT
This app was developed as a private tool for accessing databases from Android devices.
Primarily, the development was designed for Oracle databases.
It is provided free of charge and does not claim to compete with professional tools.
No warranty is provided for any damage that may result from the handling of this app.
The use of this app is at your own risk.
As this app stores its data in the file system and therefore has a file browser function, this app requires access to all directories in the file system.
This functionality offers the possibility to store your SQLs and selected data in any directories and also to import externally created SQLs into the editor of the app in order to be able to perform more complex queries that are difficult to create with an Android app.
My app will not read, change, delete or otherwise use any of your data from the file system in any way without your consent.
On Android 10 and higher my internal Filemanager is now replaced by Standard Android Open and Save File Functions, because Google does not allow "manage all files" to my app. for this i do not need "manage all files" anymore but some features are lost about this change like setting a default directory and such things.
Main Functions of this app:
- create sql statements
- unlimited resultset rows
- size of a resultset is only limited by your memory
- save/load sql statements in/from textfiles
- fix columns in a result set
- sort columns in a result set
- use dynamic variables like &input
- syntax highlight
- sql beautifier
- create explain plans
- export data to csv
- export and copy data to clipboard
- manipulation sql's like 'insert' or 'update'
RoSQL should be used in a secure network like a vpn network or a local secured network, because the traffic isn't encrypted !
MSSQL is only implemented for Android 5 and higher, not for Android 4.4.
On Android 11 or higher you have give the app file read and write permissions in your android phone settings. see special app rights on your phone. it seems to be different to set for different phones/android versions.
There is a problem (ORA-12705) with NLS (Oracle and thin client) for some countries. if your phone or tablet has a language (for example Cyrillic) , that is not supported, you can try to change the locale in the settings-window to "US" (checkbox for a US default connection). it seems to be a oracle express problem, on tests with oracle standard/enterprise databases i do not have this connect errors.
this oracle sql client uses a direct thin v8 connection for Android 4.4 nd lower and a direct thin v11 connection for android 5 and higher to your database !
- Android 5 User and higher no longer have to set compatibilty mode 8 for Oracle
- Android 4.4 User and lower have to set compatibility mode 8 (oracle10 and above) as described below:
for Oracle12c connections please set in sqlnet.ini (Server) SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
for databases equal oracle10g or 11g: SQLNET.ALLOWED_LOGON_VERSION=8
you can download still a version for Android 4.4 and lower, but it will no longer be maintained.
if your db-admin doesn't allow you direct thin connections (v8 or v11) from a Client, this app can't connect to your oracle database !
tested connections: oracle9i, oracle10g, oracle11g, oracle12c, mysql 5.5, mssql server 2016
- Google Play Store
- Free
- Tools
Store Rank
- -
Learning Django can be a tricky and time-consuming activity. There are hundreds of tutorials, loads of documentation, and many explanations that are hard to digest. However, this app enables you to use and learn Django in just a couple of days. So you want to Learn Django Web Development to develop reliable and secure applications which stand out from the crowd, rather than spending hours on boilerplate code? Then the Django framework is where you should begin. Often referred to as a 'batteries included' web development framework, Django comes with all the core features needed to build a standalone application. If you want to learn the entire process of developing professional web applications with Python and Django, then this app is for you. In the process of building four professional Django projects, you will learn about Django 3 features, how to solve common web development problems, how to implement best practices, and how to successfully deploy your applications.
In this app, you will build a blog application, a social image bookmarking website, an online shop, and an e-learning platform. Step-by-step guidance will teach you how to integrate popular technologies, enhance your applications with AJAX, create RESTful APIs, and set up a production environment for your Django projects. You will also learn Python programming covering beginner to advanced concepts. You will also learn the basics of web development like HTML, CSS, JavaScript. As you progress, you'll learn various practical skills, including how to serve static files to add CSS, JavaScript, and images to your application, how to implement forms to accept user input, and how to manage sessions to ensure a reliable user experience.
What you will learn?
- Learn HTML5 Programming
- Learn CSS3 Programming
- Learn JavaScript Programming
- Learn Python Programming
- Learn Django Development
- Build real-world web applications
- Learn Django essentials, including models, views, ORM, templates, URLs, forms, and authentication
- Create a new application and add models to describe your data
- Use views and templates to control behavior and appearance
- Implement advanced features such as custom model fields, custom template tags, cache, middleware, localization, and more
- Create complex functionalities, such as AJAX interactions, social authentication, a full-text search engine, a payment system, a CMS, a RESTful API, and more
- Integrate other technologies, including Redis, Celery, RabbitMQ, PostgreSQL, and Channels, into your projects
- Deploy Django projects in production using NGINX
- Learn MySQL Database
- Learn PostgreSQL Database
So what are you waiting for! Download now and start your Django / Python Developer Career.
- Google Play Store
- Paid
- Education
Store Rank
- -
RoSQL - SQL Client VS. 
Learn Django 3 - DjangoDev PROJanuary 3, 2025