Author

Topic: Hiring python/SQL/HTML developer (Read 151 times)

legendary
Activity: 1568
Merit: 6660
bitcoincleanup.com / bitmixlist.org
February 29, 2024, 05:41:04 AM
#13
You're quite in luck as I happen to have good experience in all three of them.

Hit me up.

AI is meant to handle stuff like this but unless you've a proper prompt, even it could give you false positives.

No it's not. Large language models can only print what other people have been writing a lot inside its training data. That's why when you ask an LLM to create an HTML page for you or a python script to make an SQL table, it can do it easily, but if you ask it for example any code related to bitcoin cryptography, it bails out as it doesn't have enough examples of it.
jr. member
Activity: 57
Merit: 1
Chainjoes.com
February 29, 2024, 12:11:44 AM
#12
This sounds like an interesting challenge but hard to achieve. Let's say you've three tables, writing "Tim" in the terminal could imply like x number of queries including joins/index etc. You would want the query spat out by the code to be exactly returning the given input and there would be multiple reasons for the given output. This will also cause issues if the tables are updated and such. AI is meant to handle stuff like this but unless you've a proper prompt, even it could give you false positives.

You could write out all of the possible SQL combinations with only a few inputs in each table and it should work out fine. But however it can be done I am willing to do it.





If anyone is interested, pm me your telegram.






I just Sent you my telegram I think We can make this work. Please check out your PMs ASAP
full member
Activity: 1708
Merit: 125
www.positivebetting.com
February 28, 2024, 08:19:10 PM
#11
This sounds like an interesting challenge but hard to achieve. Let's say you've three tables, writing "Tim" in the terminal could imply like x number of queries including joins/index etc. You would want the query spat out by the code to be exactly returning the given input and there would be multiple reasons for the given output. This will also cause issues if the tables are updated and such. AI is meant to handle stuff like this but unless you've a proper prompt, even it could give you false positives.

You could write out all of the possible SQL combinations with only a few inputs in each table and it should work out fine. But however it can be done I am willing to do it.





If anyone is interested, pm me your telegram.



newbie
Activity: 8
Merit: 0
February 28, 2024, 08:12:05 PM
#10
Sorry I think I am confusing you. The python code doesn't connect to any systems. Its a standalone code that is designed to spit out sql code that the users can then use to put in our system to look up data. Everyone using it is an employee

I think it is more clearer now. Technically speaking you can have your python script, that is basically some kind of assistant for writing SQL queries, and use some UI toolkit for python like Tkinter, PyQT, etc. to have a better experience for non technical users.

If you are sure that that's what actually meet your current needs, I think what I suggested is one possible solution specially if is just for looking up records and not modifying the DB, but you should discuss it further with any dev you choose to work with.

I hope you are able to find a dev for the job.

 
legendary
Activity: 1848
Merit: 1308
Get your game girl
February 28, 2024, 07:20:18 PM
#9
This sounds like an interesting challenge but hard to achieve. Let's say you've three tables, writing "Tim" in the terminal could imply like x number of queries including joins/index etc. You would want the query spat out by the code to be exactly returning the given input and there would be multiple reasons for the given output. This will also cause issues if the tables are updated and such. AI is meant to handle stuff like this but unless you've a proper prompt, even it could give you false positives.
full member
Activity: 1708
Merit: 125
www.positivebetting.com
February 27, 2024, 07:28:39 PM
#8
how is your user going to access this python code ?
does it have to be python, why?

I would be open to something else.

The user would be sent the python code to run, and then they can access it whenever they need to search something in the database.

so, if a user is sent the python code which is connecting to your database then whats stopping him from doing something they arent supposed to do?

Sorry I think I am confusing you. The python code doesn't connect to any systems. Its a standalone code that is designed to spit out sql code that the users can then use to put in our system to look up data. Everyone using it is an employee
jr. member
Activity: 57
Merit: 1
Chainjoes.com
February 27, 2024, 01:10:15 PM
#7
I think I know what he wants. I have some associates who can help you with this project. let's have a chat in discord to discuss this further.  My Discord: Noah.I.am#3350
member
Activity: 149
Merit: 11
February 27, 2024, 12:15:20 PM
#6
how is your user going to access this python code ?
does it have to be python, why?

I would be open to something else.

The user would be sent the python code to run, and then they can access it whenever they need to search something in the database.

so, if a user is sent the python code which is connecting to your database then whats stopping him from doing something they arent supposed to do?
full member
Activity: 1708
Merit: 125
www.positivebetting.com
February 27, 2024, 11:45:30 AM
#5
how is your user going to access this python code ?
does it have to be python, why?

I would be open to something else.

The user would be sent the python code to run, and then they can access it whenever they need to search something in the database.
member
Activity: 149
Merit: 11
February 27, 2024, 10:52:08 AM
#4
how is your user going to access this python code ?
does it have to be python, why?
full member
Activity: 1708
Merit: 125
www.positivebetting.com
February 27, 2024, 10:18:18 AM
#3
I'm asking just because I'm curious.

Are you looking for somebody that can make you a flask or django web app? (or something similar) I'm assuming since you mentioned that you needed python code and some UI with html and css that you have something a stack similar to those but because you mentioned a "python terminal" make it sound odd to me, I think my question might help make it more clear to potential devs wanting to apply.  

Whatever you can do to make it work. I am currently using visual studio to house the python code which has a terminal. I haven't done any UI so if you wanna use a web app then thats fine.
newbie
Activity: 8
Merit: 0
February 27, 2024, 01:10:09 AM
#2
I'm asking just because I'm curious.

Are you looking for somebody that can make you a flask or django web app? (or something similar) I'm assuming since you mentioned that you needed python code and some UI with html and css that you have something a stack similar to those but because you mentioned a "python terminal" make it sound odd to me, I think my question might help make it more clear to potential devs wanting to apply.  
full member
Activity: 1708
Merit: 125
www.positivebetting.com
February 26, 2024, 05:56:50 PM
#1
I got a project that I will need some simple UX through html or css or something. I need a python code that will output SQL text that an employee can simply copy and paste into our tooling to look up stuff in our database.

So basically I can send you 3 SQL tables we have and you would create a python code that will show inputs in a terminal that an applicant can type into, and then based on the inputs it will spit out the SQL code needed to look up the data.




Does this make sense?


So the python terminal may say "Name" and I might put Tim. Then the python output would say

Select *
From blah_applications
where Name = 'Tim'


Something like that, and the HTML or CSS GUI will make the terminal look nice and have boxes to input


I have some of the python done that you can checkout. Send me your pay via BTC and telegram below.
Jump to: