Skip to main content

All Questions

Tagged with
2 votes
1 answer
178 views

Prevent Column Name Collision

I have been working on a series of posts about a library to connect to databases but most of the scenarios I have to resort to some "JOIN" the problem arose when two or more tables had some ...
user avatar
3 votes
1 answer
152 views

New in PHP OOP and need opinion am I doing it the right way

I am new to using PHP OOP and decided to start learning by converting something I wrote in procedural PHP. So now I need your opinion and recommendations for my first work. One of the main reasons I ...
milenmk's user avatar
  • 147
2 votes
0 answers
688 views

Python Wrapper for Dynamic SQL

...
jpf5046's user avatar
  • 133
6 votes
1 answer
319 views

OOP Python Blackjack game with player accounts in PostgreSQL

This is an OOP version of Lastest version of my Blackjack game. Also, it now uses PostgreSQL as database. ...
Maria Laura's user avatar
2 votes
2 answers
89 views

ORM class for Posts

I'm new to PHP OOP and I'm making some tests. I have 2 classes: database and posts and the two interact with each other. Class Database: ...
eskimopest's user avatar
6 votes
1 answer
193 views

Polymorphic Data Socket Factory with Query Contingency Protocols in Python

I work on a small data team where we developed this tool when we began experiencing several job failures on our legacy big data systems. We have several data lakes, each with their own API, and until ...
Miller's user avatar
  • 533
2 votes
0 answers
1k views

Kotlin DAO with Exposed: How to reduce redundancy in classes?

I'm writing a Kotlin app that uses Exposed (https://github.com/JetBrains/Exposed) as a SQL wrapper to write and read objects from databases. The problem I'm facing is that I end up with 3 classes ...
user125756's user avatar
2 votes
0 answers
84 views

One class for MySQL and MSSQL Queries

EDIT BELOW I am trying to create resusable classes for MSSQL and MySQL queries (later also Update and Delete queries). I tried it doing the OOP-way. Here is my result: Einstellungen.vb: ...
PRCV1's user avatar
  • 21
4 votes
1 answer
25k views

Basic object-oriented PHP login, logout, and registration scripts

I am new to OOP in general and have recently started trying to develop object-oriented PHP code instead of relying on a primarily procedural style, as this is a requirement for my studies. One part of ...
Ichi's user avatar
  • 93
1 vote
1 answer
4k views

PDO Dynamic query builder

I'm trying to improve my php oop programming skills. As an exercise I wrote this class that will generate and execute dynamic sql queries. I've also writed a class to call various sanitization filters ...
user9741470's user avatar
4 votes
1 answer
121 views

Class to build and execute dynamic SQL statements

I'm uncertain about proper OOP design since my teachers are explaining OOP very vaguely. Do I need to use the constructor and the mutators like this or am I better off removing the constructor and ...
ZaxZix's user avatar
  • 41
4 votes
1 answer
311 views

App to manage a football tournament database

My question is all about class design. I have this app that is connecting to a SQL server, retrieving some tables, the user works on the data, and then it updates the database. I should say that all ...
bro840's user avatar
  • 41
1 vote
1 answer
821 views

Data Access Layer (object oriented)

I am using a global class (like a global model) that acts like a sql abstraction layer for my application. I am using it without problems now, but since the application I am creating is getting bigger,...
lightning_missile's user avatar
1 vote
2 answers
3k views

SQL Query Builder in PHP

I have made a Query Builder, (not the full version of it yet) but I wanna ask if there is someone out there, there can improve this code even more. Will be nice to know so I can code the rest in the ...
TheCrazyProfessor's user avatar
4 votes
1 answer
291 views

SQLite database for books

First, my Book object: ...
The 29th Saltshaker's user avatar

15 30 50 per page