Re: Improving MSSQL and Azure SQL support on Django

;>> to revolve around setting constraints as the tables are generated, rather >>>>> than holding off and enabling the constraints at the end of the process. >>>>> 2. Stored Procedures. These need to be loaded as an additional step >>>>> in the c

Re: Improving MSSQL and Azure SQL support on Django

as the tables are generated, rather >>>> than holding off and enabling the constraints at the end of the process. >>>> 2. Stored Procedures. These need to be loaded as an additional step >>>> in the creation of a database, and don't really have any repr

Re: Improving MSSQL and Azure SQL support on Django

per se so migrations, etc don't generally have an idea that they >>> exist. >>> >>> I'd be happy to test out what you come up with against our system. It's >>> currently serving a custom REST interface with 2-million-plus rows of >>> transactions,wi

Re: Improving MSSQL and Azure SQL support on Django

b app, >> a staff site and a suite of Tableau reports. >> >> On Thursday, November 26, 2020 at 5:40:18 PM UTC-8 vwa...@gmail.com >> wrote: >> >>> Hi All, >>> >>> Microsoft has now committed ongoing resources towards improving MSSQL >>>

Re: Improving MSSQL and Azure SQL support on Django

a staff site and a suite of Tableau reports. > > On Thursday, November 26, 2020 at 5:40:18 PM UTC-8 vwa...@gmail.com wrote: > >> Hi All, >> >> Microsoft has now committed ongoing resources towards improving MSSQL and >> Azure SQL support for Django. We're currently f

Re: Improving MSSQL and Azure SQL support on Django

20 at 5:40:18 PM UTC-8 vwa...@gmail.com 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 django-mssql-backend > <https:

Re: Improving MSSQL and Azure SQL support on Django

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

Re: Improving MSSQL and Azure SQL support on Django

am excited to see your PRs against the repo. Cheers, Florian On Friday, November 27, 2020 at 2:40:18 AM UTC+1 vwa...@gmail.com wrote: > Hi All, > > Microsoft has now committed ongoing resources towards improving MSSQL and > Azure SQL support for Django. We're currently focused on

Re: Improving MSSQL and Azure SQL support on Django

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 django-mssql-backend <https://github.com/ESSolutions/django-mssql-backend>, adding testing pip

Re: Improving MSSQL and Azure SQL support on Django

Hi Sean, just an update from what I know. We are still waiting for a reply from Microsoft. They're a large company, so understandably, it takes a little while. For now, if people need to get onto Django 2.2 for long term support (which will last until April, 2022), you can use this package:

Re: Improving MSSQL and Azure SQL support on Django

Hello, It seems like this issue has lost momentum. Is this still something that's on anyones radar? It looks like django-pyodbc-azure is not actively maintained anymore (it looks like Michaya has taken a hiatus from GitHub). It also looks like there's a small community potentially popping up

Re: Improving MSSQL and Azure SQL support on Django

Hi Kunal, welcome to the Django community! django-pyodbc-azure is the best maintained SQL Server engine I've found, and it typically gets updated a little more quickly than this. However, Michaya who maintains the package has been extremely busy lately, and said it will take him a few more

Re: Improving MSSQL and Azure SQL support on Django

Hi, I am new to Django, but planning to use Django 2.0 for my newest project. I am using MSSQL db and hence facing issues with it. Anyone working on getting an MSSQL backend that works with Django 2.0? (Couldn't find one that's up to date including django-pyodbc-azure). Any help would be much

Re: Improving MSSQL and Azure SQL support on Django

Microsoft probably will take Django support to the next level with Windows Subsystem for Linux. It's still beta but a very promising one. Not only it should make compiling Python module binaries (like lxml) much easier, it also fixes binary / nix specific support of node.js / Ruby packages. On

Re: Improving MSSQL and Azure SQL support on Django

Quick update of the current status of things related to MSSQL. The most actively maintained MSSQL backend that I'm aware of is django-pyodbc-azure (also works with standalone SQL Server). Michiya has been doing an amazing job supporting that backend. There has been no real movement toward there

Re: Improving MSSQL and Azure SQL support on Django

I wonder if there have been any updates on MS support for a official/supported MS SQL Django driver? Did the offered engineering effort from MS ever come through? Given the availability of of MS SQL on Linux, as well as support for Django in Visual Studio, it would be great if this came to

Re: Improving MSSQL and Azure SQL support on Django

If people are planning on being in Philadelphia around the time of DjangoCon this summer (July 17th - 22nd), I'd be happy to arrange space for a meeting / code sprint and provide food. Django sprints are on July 21st / 22nd which would be ideal; or the weekend afterwards. I'm on the DjangoCon

Re: Improving MSSQL and Azure SQL support on Django

Hey Tim, We are continuing to follow up with Michael and have reached out to Michiya as well. We have not abandoned the idea of providing engineering resources either, and are still working out the logistics with Michael as he will help direct our efforts. We are syncing again in mid-April

Re: Improving MSSQL and Azure SQL support on Django

Yes, I wonder if Microsoft abandoned the idea of providing engineering resources to help out projects like django-mssql or if things are just moving really slowly? I'm not aware of any follow up related to that idea since Michael, Michiya, and I visited Microsoft in October. On Wednesday,

Re: Improving MSSQL and Azure SQL support on Django

"Improve documentation/examples [decrease confusion]: There's already so much awesome content out there on getting started with Django (but not many are referencing MSSQL as the db of choice or why MSSQL is a great option)." I wouldn't think of MSSQL as a great option for django at least until

Re: Improving MSSQL and Azure SQL support on Django

Hey Tim, We've gotten lots of questions about the tools when we announced SQL Server on Linux. I am curious; what are the DB management/development tasks that are being performed by your coworkers? What are they using SSMS for? I am interested in learning more. [Perhaps we can follow up by

Re: Improving MSSQL and Azure SQL support on Django

[slightly off-topic] I'm wondering if this will extend to SQL Server Management Studio. While I'm mainly a command line basher, many of coworkers are married to the GUI. I've found SSMS blows the competition out of the water when it comes to DB management GUIs. I'm wondering if this means SSMS

Re: Improving MSSQL and Azure SQL support on Django

Wow, that's really great news! I haven't used mssql for a number of years but it was always very nice to work with. Having it available to run on linux will make it much easier for the Django community to test against mssql, provided we're able to get/develop an appropriate driver and backend.

Re: Improving MSSQL and Azure SQL support on Django

Hi all, On interacting with several Django developers and committers, one of the questions often came up, can I use SQL Server on non Window OS's? I wanted to share that today Microsoft announced SQL Server availibility on Linux -

Re: Improving MSSQL and Azure SQL support on Django

Hey Folks, My name is Vin and I work with Meet in the Microsoft SQL Server team. Just wanted to let you all know we are still looking into how we can better improve and support MSSQL for the Django framework. We’ll continue to sync with Michael and let you know of any updates soon.

Re: Improving MSSQL and Azure SQL support on Django

Hi Cristiano, I support a bunch of developers on Windows (and Mac and Linux). You've probably heard this before, but Vagrant has really been a game changer for us. We're a RedHat shop, so I've built a CentOS vagrant box our developers can easily spin up for development purposes. It really

Re: Improving MSSQL and Azure SQL support on Django

Tim Allen, What you said about compiling the C dependencies on a similar machine and then upload it all together indeed works (it was one of the options) but caused some other issues (ie: we usually develop on Windows, and also the compiled libraries are very platform specific) and performance

Re: Improving MSSQL and Azure SQL support on Django

Thanks to everyone for their efforts; my workplace has a mix of SQL Server and PostgreSQL, heavier on the SQL Server side. Due to some groups reliance on SSIS and tight SQL Server integration with data vendors, that isn't going to change any time soon, so this is project is one we're following

Re: Improving MSSQL and Azure SQL support on Django

There has not been much direct progress with regards to an SQL Server database backend. My personal life keeps getting in the way and the test suite takes a disturbingly long time on my computer against MSSQL. Despite me being busy, others have helped move things forward. Some have contributed

Re: Improving MSSQL and Azure SQL support on Django

I'm interested in the progress of this as well :) Sorry I didn't read through all the posts, mostly the first ones about the idea. I would like to know, have you guys decided on which adapter to use? I have had a project where we needed to connect to SQL Server from a linux machine (actually

Re: Improving MSSQL and Azure SQL support on Django

is there any update about the progress of this? -- Fábio C. Barrionuevo da Luz Palmas - Tocantins - Brasil - América do Sul Em terça-feira, 13 de outubro de 2015 18:12:55 UTC-3, Tim Graham escreveu: > > If anyone is interested in listening in on the meetings with Microsoft > engineers

Re: Improving MSSQL and Azure SQL support on Django

If anyone is interested in listening in on the meetings with Microsoft engineers (Wednesday and Thursday 9am-5pm Pacific), let me know and I'll send you the Skype link. On Friday, October 2, 2015 at 11:53:17 AM UTC-7, Meet Bhagdev wrote: > > > > On Thursday, October 1, 2015 at 12:32:25 PM

Re: Improving MSSQL and Azure SQL support on Django

Hi Tim, Hope this helps, please let me know if you have any more questions. On Thursday, October 1, 2015 at 12:32:25 PM UTC-7, Tim Graham wrote: > > Hi Meet, > > I was wondering > > 1. If you have any progress updates since your last message? > *Yes, engineers on my team and I are

Re: Improving MSSQL and Azure SQL support on Django

Hi Meet, I was wondering 1. If you have any progress updates since your last message? 2. If you have any further details on the schedule for the time in Seattle in a week and a half? (including video conference details for those unable to attend in person) 3. If myself or the other

Re: Improving MSSQL and Azure SQL support on Django

Hey team, as promised, here are the simple tests I put together to benchmark pyodbc vs pymssql. Be kind, this was Python I wrote a long time ago! https://github.com/FlipperPA/pyodbc-pymssql-tests I've included example output on the README. Very basic, but useful. On Wednesday, September 16,

Re: Improving MSSQL and Azure SQL support on Django

Thanks for all of your efforts, Aymeric, I've been following your project since its inception - I'm FlipperPA on GitHub. On Sunday, September 13, 2015 at 4:59:34 AM UTC-4, Aymeric Augustin wrote: > > Did you mean “pyodbc outperforms pymssql”? Or did you go with pyodbc > despite lower

Re: Improving MSSQL and Azure SQL support on Django

Hi Tim, Thanks for sharing your experience! > On 13 sept. 2015, at 01:48, Tim Allen wrote: > We have a test suite performing table creates / destroys, basic CRUD > operations, stored procedure execution, and more against both pyodbc and > pymssql. > pymssql

Re: Improving MSSQL and Azure SQL support on Django

Sorry to have missed meeting you at DjangoCon, Meet, but I'll add my findings here to the record. By way of background, I work at The Wharton School, where we're a Python/Django (on RHEL) and SQL Server shop. I was responsible for implementing a working configuration for Django, starting with

Re: Improving MSSQL and Azure SQL support on Django

On Wednesday, September 2, 2015 at 3:05:23 PM UTC-7, Ramiro Morales wrote: > > Hi all, > > On Fri, Aug 21, 2015 at 2:39 PM, Meet Bhagdev > wrote: > > Hi Django Committers, > > > > > > > > My name is Meet Bhagdev, I work in the Database Systems engineering team > at

Re: Improving MSSQL and Azure SQL support on Django

Hi Tim, I will definitely be driving the initial planing and will help lay out the ground work. There will be other engineer(s) who will work on contributing to third party adapter(s) and the Django project(eventualy). But first, we need to figure out the ask and the nature of work required.

Re: Improving MSSQL and Azure SQL support on Django

Hi all, On Fri, Aug 21, 2015 at 2:39 PM, Meet Bhagdev wrote: > Hi Django Committers, > > > > My name is Meet Bhagdev, I work in the Database Systems engineering team at > Microsoft in Seattle, WA. My focus is the APIs used to connect to and use > Azure SQL Database and SQL

Re: Improving MSSQL and Azure SQL support on Django

Hi Meet, Will you be the primary contributor/maintainer from Microsoft of this project or will their be other engineers at Microsoft involved? I'd like to understand the bus factor on your side and how much time resources you plan to provide. To give you an idea of how our community works

Re: Improving MSSQL and Azure SQL support on Django

Hi Russ,Tim That is a great idea. I am going to try to engage with the team at Microsoft who is in charge of the sponsorship. I plan on attending the conference so I will see some of you there. @Tim: I agree that a lot of ground work needs to be done in terms of testing out the current third

Re: Improving MSSQL and Azure SQL support on Django

Hi Russ,Tim That is a great idea. I am going to try to engage with the team at Microsoft who is in charge of the sponsorship. I plan on attending the conference so I will see some of you there. @Tim: I agree that a lot of ground work needs to be done in terms of testing out the current third

Re: Improving MSSQL and Azure SQL support on Django

Hi Tim, Meet I know this is very late to be mentioning, but one idea that worth raising: DjangoCon US is next week (in Austin). Thursday and Friday are coding sprints, where there will be many people (including a good chunk of the core team) looking for projects to hack on. Microsoft is already

Re: Improving MSSQL and Azure SQL support on Django

To arrive at the best solution, I think a lot of discussion needs to happen on this mailing list before October. As for me, besides the name of some existing packages that offer SQL Server/Azure support, I know very little about the current landscape so I really wouldn't have anything to offer

Re: Improving MSSQL and Azure SQL support on Django

Hi Tim, Thanks for bringing it up. Yes, we will have developers who will engage with Django developers (like yourself) during the workshop. The goals of the October workshop are to: 1) Get to know each other and begin building a relationship 2) Get in a room with Microsoft

Re: Improving MSSQL and Azure SQL support on Django

By "we" do you mean the engineers at Microsoft who will be working on this? Will they be doing any planning for this before the meet up in October? I'd like to know more specifics about the agenda and goals for the workshop. Also, I wanted to make sure my question about a videoconferencing

Re: Improving MSSQL and Azure SQL support on Django

Hi Meet, The Fellowship committee has just approved this, so go ahead and plan whatever you need to plan. Yours, Russ Magee %-) On Sat, Aug 29, 2015 at 6:21 AM, Meet Bhagdev wrote: > Thanks Russ! > > On Tuesday, August 25, 2015 at 6:34:54 PM UTC-7, Russell Keith-Magee

Re: Improving MSSQL and Azure SQL support on Django

Thanks Russ! On Tuesday, August 25, 2015 at 6:34:54 PM UTC-7, Russell Keith-Magee wrote: > > > On Sat, Aug 22, 2015 at 8:28 PM, Tim Graham > wrote: > >> I agree it would be great to get some help running the Django tests on >> Windows. I run them in a local virtual machine

Re: Improving MSSQL and Azure SQL support on Django

On Sat, Aug 22, 2015 at 8:28 PM, Tim Graham wrote: > I agree it would be great to get some help running the Django tests on > Windows. I run them in a local virtual machine every so often, but I would > love to be able to delegate fixing Windows issues. Meet, can your team

Re: Improving MSSQL and Azure SQL support on Django

Absolutely agree with Tim here. We need to start exploring all the cool open sourced third party adapters. Borrowing/adopting them definitely seems like the way to go about things instead of re inventing the wheel. I tried doing some research and came across the following: 1. Django-mssql

Re: Improving MSSQL and Azure SQL support on Django

I guess the first step is to identify which third-party backend(s) we'll target to adopt officially (or at least borrow from heavily). For example, will we need separate backends for MSSQL and Azure? (Knowing nothing about the landscape myself, this question could be nonsensical.) Is this

Re: Improving MSSQL and Azure SQL support on Django

On Saturday 22 August 2015 13:28:31 Aymeric Augustin wrote: > > There isn’t such a clear story for running Django on Linux. This led me to > write https://github.com/aaugustin/django-pymssql. Alternatives include > https://github.com/denisenkom/django-sqlserver and >

Re: Improving MSSQL and Azure SQL support on Django

I agree it would be great to get some help running the Django tests on Windows. I run them in a local virtual machine every so often, but I would love to be able to delegate fixing Windows issues. Meet, can your team provide ongoing help with fixing Windows-specific issues in Django, even if

Re: Improving MSSQL and Azure SQL support on Django

Hello Meet, On 21 août 2015, at 19:39, Meet Bhagdev wrote: > We’d love for Django users to have a solid option to use MSSQL and Azure SQL > if they wish, and it would be great to make this option a reality. Even though this isn’t what you’re asking for :-) I’ll take

Improving MSSQL and Azure SQL support on Django

Hi Django Committers, My name is Meet Bhagdev, I work in the Database Systems engineering team at Microsoft in Seattle, WA. My focus is the APIs used to connect to and use Azure SQL Database and SQL Server (MSSQL). Example APIs are ODBC, JDBC, ADO.NET, etc. We’d love for Django users