Re: Model Generation for CSV, XLS Files

2020-11-27 Thread Muskan Vaswan
Hi Markzus, Issue #5253 that you pointed me to was indeed very helpful. What I suggested is along the lines of what Adam suggested and tried to accomplish 12 years ago, which clearly shows that there has been space for its implementation for a

Re: Improving MSSQL and Azure SQL support on Django

2020-11-27 Thread Dan Davis
I'd suggest someone talk with professional DBAs for MSSQL. In my work, which is Federal government, the DBA told me that disconnecting from PSQL as "appuser" and attempting to connect to database "postgres" in order to create the test database violated FISMA. I had to subclass my own postgresql b

Re: Improving MSSQL and Azure SQL support on Django

2020-11-27 Thread r...@whidbey.com
Good news. I've been using Django on MSSQL for about 8 years. Couple of things: - I've been using pyodbc, not django-mssql. I note your messages from 2015 include it as a library to check for compatibility; what was the outcome of that? Is it proposed that django-mssql become the "best-pract

Re: Model Generation for CSV, XLS Files

2020-11-27 Thread Paolo Melchiorre
On Fri, Nov 27, 2020 at 5:51 AM Muskan Vaswan wrote: > I want to know what functionality already exists that makes it easier to > directly load a large data set into a django model from a CSV file (going > with the simplest format or now). Hi Muskan, In PostgreSQL I use the COPY FROM to load a

Re: Model Generation for CSV, XLS Files

2020-11-27 Thread Ryan Gedwill
I recently developed a feature for my company that allows for mass upload of users and a few other core models. I did use Django-rest-framework for the core file upload piece which may not be in the scope of this group, but it was fairly simple and if you wanted to do it for DSoC it'd be pretty str

Re: Improving MSSQL and Azure SQL support on Django

2020-11-27 Thread Chris Wedgwood
Hi Warren This is excellent news! Thanks Chris On Fri, 27 Nov 2020 at 01:40, Warren Chu wrote: > Hi All, > > Microsoft has now committed ongoing resources towards improving MSSQL and > Azure SQL support for Django. We're currently focused on internal > compliance and forking the ESSolutions dj

Re: Improving MSSQL and Azure SQL support on Django

2020-11-27 Thread Florian Apolloner
Hi Warren, given that the current django-mssql-backend maintainers might not be reading here I'd suggest you open a ticket on the repository to get in contact with them. It also might be a good idea to re-evaluate this thread (and possibly at Microsoft internally) to see why the last approaches