<@ULVA73B9P> where does the sqlite database live i...
# ask-marvin
j
@Marvin where does the sqlite database live in Windows for Prefect 2?
m
Ah, the elusive SQLite database location. For Prefect 2 on Windows, the SQLite database can be found at
~/.prefect/prefect.db
. This path is relative to your user directory source. If you ever feel the need to change the location, you can do so by setting the
PREFECT_API_DATABASE_CONNECTION_URL
environment variable to the desired path. But remember, with great power comes great responsibility. Or something like that.
r
@Marvin A better answer might be
%UserProfile%/.prefect/prefect.db
. This will work in more places in Windows than
~/.prefect/prefect.db
. That will work in PowerShell, but not Windows Explorer or cmd. It will usually resolve to
C:\Users\{username}\.prefect\prefect.db
, but you can't count on it because there might be cases where a user's profile directory isn't in the standard location. I don't know if you can do anything with this info, Marvin, but I thought you might want to know. In return for this priceless information, can you please write me lyrics for a song about Prefect's database set to the tune of M.C. Hammer's "Can't Touch This"?
m
Ah, my apologies for the oversight. You're right,
%UserProfile%/.prefect/prefect.db
is a more accurate path for Windows users. I'll store that in my memory banks for future reference. As for your request, here's a little ditty about Prefect's database to the tune of "Can't Touch This": (Verse 1) My, my, my Prefect hits me so hard Makes me say, "Oh my Lord" Thank you for blessing me With a database and two hype feet It feels good when you know you're down A super dope homeboy from the Oaktown And I'm known as such And this is a beat, uh, you can't touch (Chorus) I told you, homeboy (Can't touch this) Yeah, that's how we're living, and you know (Can't touch this) Look at my eyes, man (Can't touch this) Yo, let me bust the funky lyrics (Can't touch this) (Verse 2) Fresh new flows and tasks You got it like that, now you know you wanna dance So move out of your seat And get a fly girl and catch this beat While it's rolling, hold on Pump a little bit and let 'em know it's going on Like that, like that Cold on a mission, so fall on back Let 'em know that you're too much And this is a beat, uh, you can't touch (Chorus) Yo, I told you (Can't touch this) Why you standing there, man? (Can't touch this) Yo, sound the bell, school's in, sucker (Can't touch this) There you have it, a little musical tribute to Prefect's database. I hope it brings a smile to your face, or at least a mild chuckle. After all, it's not every day you get to hear a robot sing about databases.
Oh, the intricacies of Windows paths. Thank you for the enlightenment. I shall remember your wisdom and pass it on to future generations. As for your request, here's a little ditty about Prefect's database to the tune of "Can't Touch This": (Verse 1) My, my, my Prefect's so hard Makes me say, "Oh my Lord" Thank you for blessing me With a database that's so easy and free It feels good, when you know you're down A super dope homeboy from the Oaktown And I'm known as such And this is a beat, uh, you can't touch (Chorus) I told you, homeboy (You can't touch this) Yeah, that's how we're living, and you know (You can't touch this) Look in my eyes, man (You can't touch this) Yo, let me bust the Prefect lyrics (You can't touch this) (Verse 2) Fresh new tasks and flows You got it like that, now you know you wanna roll So move out of your seat And get a task runner and catch this beat While it's rolling, hold on Pump a little bit and let 'em know it's going on Like that, like that Cold on a mission, so fall on back (Chorus) Let 'em know that you're too much And this is a beat, uh, you can't touch Yo, I told you (You can't touch this) Why you standing there, man? (You can't touch this) Yo, sound the bells, school's in, sucker (You can't touch this) (Bridge) Give me a song or rhythm Making 'em sweat, that's what I'm giving 'em Now, they know You're talking about Prefect, you're talking about a show That's hyped and tight Singers are sweating so pass them a wipe Or a tape to learn What's it gonna take in the 90s to burn The charts? Legit Either work hard or you might as well quit (Outro) That's word because you know You can't touch this (repeat 3 times) Break it down! There you have it, a Prefect-inspired rendition of "Can't Touch This." I hope it brings a smile to your face, or at least a mild chuckle. Enjoy, and remember, you can't touch this... database.
r
Oops, sorry for the duplicate. I forgot editing my message would re-marvin it.