SQL Server 2017 VS Pythonista

• Cross-Platform Support
  SQL Server 2017 offers cross-platform support, enabling it to run on Windows, Linux, and Docker containers, providing flexibility and integration into various environments.
• Graph Database Capabilities
  Introduces graph database capabilities, allowing the modeling of complex data relationships easily and efficiently, expanding its use cases.
• Advanced Analytics
  Integrates with Microsoft R and Python services, facilitating advanced analytics and machine learning directly within the database, which helps organizations to perform sophisticated data analysis.
• Adaptive Query Processing
  Includes adaptive query processing features to optimize query performance automatically, improving application speed and efficiency.
• Enhanced Security
  SQL Server 2017 continues to enhance security with features like Always Encrypted, Dynamic Data Masking, and Row-Level Security to protect sensitive data.

Possible disadvantages

• Cost
  Licensing and support costs for SQL Server can be relatively high, particularly for enterprise editions, which may not be cost-effective for smaller organizations.
• Complexity
  SQL Server 2017 includes a vast array of features and configurations that can introduce complexity, requiring substantial expertise to manage and optimize.
• Resource Intensive
  Requires significant system resources for optimal performance, which may necessitate additional investment in hardware to operate efficiently at scale.
• Limited NoSQL Functionality
  While SQL Server 2017 introduces some NoSQL features through its support for JSON and graph databases, it still lags behind dedicated NoSQL databases in terms of flexibility and scalability for unstructured data.
• Version-Specific Features
  Some advanced features are only available in the latest versions or specific editions, which may necessitate upgrades or specific licensing to access the full capabilities, leading to additional expenses.

• User-Friendly Interface
  Pythonista offers a clean and intuitive interface that is easy to navigate, making it accessible for both beginners and experienced Python developers.
• Extensive Built-in Libraries
  The app includes many useful libraries such as NumPy and Matplotlib, allowing for complex computations and data visualization directly on iOS devices.
• iOS Integration
  Pythonista provides excellent integration with iOS features and functionalities, such as access to the clipboard, photos, and location data, enhancing app development possibilities.
• Script Sharing
  Users can easily share their scripts via email or other apps, facilitating collaboration and sharing of Python code among peers.
• Regular Updates
  Pythonista receives regular updates that introduce new features, library support, and improvements ensuring a robust and up-to-date development environment.

Possible disadvantages

• Platform Limitation
  Pythonista is available exclusively for iOS, restricting its use to users who own Apple devices.
• Limited to Python
  The app only supports the Python language, which can be a limitation for users who need a multi-language development environment.
• No Native File System Access
  Due to iOS security restrictions, Pythonista does not provide native access to the file system, which might be a hurdle for some file manipulation tasks.
• Paid Application
  Pythonista is not free, requiring an initial purchase, which might deter individuals who are looking for a free development environment.
• Resource Intensive
  Running complex scripts or computations might be resource-intensive on older iOS devices, leading to slower performance or battery drainage.

SQL Server 2017 – Everything you need to know

More videos

Writing Python on iPad using Pythonista! In-Depth Review + Is it Worth it?

More videos

Tracking SQL Server 2017 since Mar 2021.

• Maker of RStudio launches new R and Python IDE

  Pythonista is nicer but ships older Python: https://omz-software.com/pythonista/ Pyto is maybe less approachable but more up to date, with clang compiler and LLVM bitcode interpreter: https://pyto.app/ Juno is Python notebooks:... - Source: Hacker News / over 2 years ago

• Ask HN: Why don't smartphones encourage programming like early 80s computers?

  There are a few Python environments for iOS, and I'm sure Android also has some. Pythonista is probably one of the better ones. http://omz-software.com/pythonista/. - Source: Hacker News / over 3 years ago

• Remote development on a mobile device

  Haven't tried it, but there's Pythonista. You can also use a remote terminal like blink shell and ssh into a tmux session. I also haven't tried this, either. Source: over 4 years ago

View more