A database is any organized collection of data organized to provide efficient retrieval.
2
votes
1answer
89 views
reusable data access class in C#
Below is my attempt at the beginnings of a reusable ado.net data access class. Please let me know of any improvements that I could make.
Thanks!
public class DataAccess : IDisposable
{
...
5
votes
1answer
71 views
PHP Login Authentication with BCrypt
So I have a php authentication script and everything works fine. But I'm very unsure about the way I programmed it (i hardcoded some stuff) and I was hoping stack could look through this and point out ...
2
votes
2answers
71 views
My database schema
I'm not sure if this would be okay to put here since it doesn't have code to look at, but this is my database I'm trying to create for an online firearm store. I'm new to database design and ...
4
votes
1answer
83 views
Please review my PDO Database wrapper
The subject is this small project - PHP/MySQL Database wrapper
The three main goals of this projects are:
Easy way to map database columns to object properties
Simple solution to insert or update ...
2
votes
1answer
64 views
Is my ERD design for “Adding Friends Capability” is good enough? [closed]
I have a school project to create a simple networking site, And I want to know if my database design is good. I'm open for any suggestions to improve my design thanks!
4
votes
1answer
51 views
Is this MySQL database structure acceptable or can it be improved?
Recently I've tried to teach myself basic things about MySQL databases, however I received some help on stackoverflow with creating a good database structure trying to avoid redundancy as much as ...
2
votes
1answer
86 views
Semi-Repost: How can I improve my PHP model for my html5/js mobile app?
I was advised, rightfully so, to simplify my question.
I am posting the a section of the model of my application.
Any/all feedback would be very helpful as I am trying to build my PHP skills, but I ...
3
votes
1answer
140 views
Is my base class constructed correctly?
I have tables that use BulkManager to save data to database.
I moved common functionality to BulkTableBase. Because creation of BulkManager depends on params of each Table I create the BulkManager in ...
2
votes
0answers
59 views
My first implementation of mongoDB
I'm new to Code Review, my assumption is that it is a place I can get feedback on working code that I've built, I hope that is right.
This is my first implementation of mongoDB, much much more to ...
2
votes
1answer
125 views
Is the following database class safe?
I was looking for a php class to handle all database operations (MySQL) and came across the following class. Someone please help me telling if this uses Prepared Statements correctly to make my web ...
2
votes
3answers
79 views
Referential MySql Design
How does this look? It has been over a year since my database concepts class and I have never worked with MySql. I have chosen InnoDB as my engine because of foreign key support using UTF-8 based on ...
3
votes
2answers
123 views
Best practices to protect a database from bad data
I'm just getting into SQL injection and data sanitization and seeking some advice on my script to get started. I have made this simple program which allows the user to enter their name into a form and ...
5
votes
2answers
151 views
Is this PDO wrapper structure dynamic? and can using self:: rather than $this cause problems?
<?php
class Database
extends PDO
{
/*@var mixed $stmt Used as a temporary variable to hold queries*/
private $stmt = Null;
/*@var $scopeSelectVar Used as a temporary variable to hold ...
3
votes
4answers
109 views
Should I break my DAO into one DAO class for each transfer object?
As a learn-by-doing project to learn java webapps I'm creating a website for registering and displaying happenings using JSP/Servlets, Apache Tomcat server, JDBC and a MySQL database.
I use JSP for ...
2
votes
1answer
92 views
Is this an efficient way of accessing the database
**EDIT I asked this question yesteday when I was unregistered, and now I can't seem to comment on the question or mark the answer as correct but I would like to say thank you for taking the time to ...
